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:
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:
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.
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).
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.