Settling Unpaid Dues Against Advance Deposit through a Delinquency Process

Oracle Revenue Management and Billing enables you to settle the unpaid bill amount of a parent customer using the advance deposit available at the parent customer or policy level through a delinquency process. For example, an advance deposit of $1000 is received from the parent customer through multiple payments as shown below:

The following table lists the advance deposit payments that are received from the parent customer through multiple payments.
Advance Deposit Payments
Payment Event ID Payment ID Payment Date Payment Amount Payment Segment (SA1) Match Event Match Event Status
PE1 P1 01-Jan-2020 200 -200 ME1 Open
PE2 P2 05-Jan-2020 200 -200 ME2 Open
PE3 P3 10-Jan-2020 200 -200 ME3 Open
PE4 P4 11-Jan-2020 200 -200 ME4 Open
PE5 P5 15-Jan-2020 200 -200 ME5 Open
Actual Deposit -1000
SA1 Contract Balance -1000

An advance deposit delinquency process is created for the parent customer which includes two bills - B1 and B2 with the bill segments as shown below:

The following table lists two bills - B1 and B2 with the bill segments belonging to a parent customer for which an advance deposit delinquency process is created.
Bill Bill Segment Amount
B1 - 300
BSEG1 (SA2) 200
BSEG2 (SA3) 100
B2 - 400
BSEG1 (SA2) 250
BSEG2 (SA3) 150

When the apply advance deposit delinquency event is triggered, the system will create four debit adjustments and one credit adjustment as shown in the below table. Note that the system will create the debit adjustments against the payment segments on the advance deposit contract using the debit adjustment type given in the C1-APPADVDEP algorithm. While creating the debit adjustments, the system will consider the payments in the ascending order of the payment date. In addition, the system will create one credit adjustment using the credit adjustment type given in the C1-APPADVDEP algorithm. This credit adjustment would be matched later in the delinquency process.

The following table lists the four debit adjustments and one credit adjustment which the system will create when the apply advance deposit delinquency event is triggered.
Advance Deposit Payments Adjustment
Payment Event ID Payment ID Payment Date Payment Amount Payment Segment (SA1) Match Event Match Event Status Adjustment Match Event Match Event Status
PE1 P1 01-Jan-2020 200 -200 ME1 Open 200 (SA1) ME1 Balanced
PE2 P2 05-Jan-2020 200 -200 ME2 Open 200 (SA1) ME2 Balanced
PE3 P3 10-Jan-2020 200 -200 ME3 Open 200 (SA1) ME3 Balanced
PE4 P4 11-Jan-2020 200 -200 ME4 Open 100 (SA1) ME4 Open
PE5 P5 15-Jan-2020 200 -200 ME5 Open
Actual Deposit -1000
SA1 Contract Balance -1000
Credit Adjustment (SA1) -700 - -

The system will then create an offset request using the offset request type given in the C1-APPADVDEP algorithm. In the offset request, the system will include the credit adjustment (-$700) and two bills - B1 and B2 for which the delinquency process is created. The system will then automatically process the offset request and create the offset request adjustments as shown in the below table. Note that the advance deposit is applied in the ascending order of the bill date. If two or more bills have the same bill date, the system applies the advance deposit in the ascending order of the unpaid amount (i.e. lowest unpaid amount is paid first).

The following table lists the offset request and the offset request adjustments for which the delinquency process is created.
Offset Request
Credit Items Debit Items
Adjustment Offset Request Adjustment Offset Adjustment Amount Match Event Match Event Status Bill Bill Segment Offset Request Adjustment Offset Adjustment Amount Match Event Match Event Status
CA1 (SA1) OA11 300 ME10 Balanced B1 BSEG1 (SA2) OA2 (SA2) -200 ME6 Balanced
BSEG2 (SA3) OA3 (SA3) -100 ME7 Balanced
OA12 400 ME10 Balanced B2 BSEG1 (SA2) OA4(SA2) -250 ME8 Balanced
BSEG2 (SA3) OA5(SA3) -150 ME9 Balanced

Once the offset request adjustments are created, the system creates a customer contact depending on whether the advance deposit is fully or partially utilized to pay the delinquent bills. The customer contact is created for the parent customer or for the main customer of the account depending on whether the delinquency process is created at the person or account level. In addition, the system stamps the delinquency process ID as a characteristic on the customer contact and on the advance deposit payments (used for offsetting; in this case P1, P2, P3, and P4). The system considers the characteristic type given in the C1-APPADVDEP algorithm. For more information about the algorithm, refer to Delinquency Event Type section.

The status of the delinquency process will remain as Delinquency In Progress. On executing the C1-DPMON batch, the system checks whether the delinquency process meets the cancel criteria. If so, the system will change the status of the delinquency process to Canceled.

For more information about the advance deposit delinquency process, see Advance Deposit Delinquency Process.