Account Level Refund/Write Off

Oracle Revenue Management and Billing enables you to create a refund/write off request at the account level. A new field named Adjustment Level is available while defining a refund/write off request. It allows you to control how the refund/write off adjustment should be created for the refund/write off request. It supports the following values:

• Account - Used when you want to create the refund/write off request at the account level. Here, the refund/write off adjustment is created against the netting contract of the account. This option is only applicable for the health insurance domain.

• Bill - Used when you want to create the refund/write off request for a bill. Here, the refund/write off adjustment is created against the netting contract of the account. This option is only applicable for the financial services domain.

• Segment - Used when you want to create the refund/write off request for a bill, bill segment, adjustment, or payment of an account. Here, the refund/write off adjustment is created against the bill segment, adjustment, or payment segment, respectively. If you select this option, the system behaves in the traditional manner.

If you do not specify the value for the Adjustment Level field, the system considers the value defined in the Default Adjustment Level option type of the C1_​REFWO feature configuration. If you select the Account option from the Adjustment Level list, the system checks the account balance while creating the refund/write off request. If the account balance is zero, the system throws an appropriate error message and does not allow you to create the refund/write off request at the account level. However, if the account balance is in credit, the system allows you to create a refund request for the account. Similarly, if the account balance is in debit, the system allows you to create a write off request for the account.

While creating a refund/write off request at the account level, the system, by default, sets the total refund/write off amount to the account balance. You cannot edit the refund/write off amount. Even, the post processing algorithms cannot update the refund/write off amount in the refund/write off request.

Before creating the refund/write off request at the account level, you need to do the following:

• Attach the C1-NTACBAL algorithm to the Netting Account Balance system event in the Algorithms tab of the Installation Options - Framework screen

• Set the netting contract type on the respective refund/write off request type

The system invokes the C1-NTACBAL algorithm while processing the refund/write off request where the adjustment level is set to Account. The C1-NTACBAL algorithm creates transfer adjustments on the netting contract of the account. The transfer adjustment creation process slightly varies depending on the adjustment level that is selected while defining a refund/write off request.

If the adjustment level is set to Account, the system checks whether a netting contract created using the netting contract type (specified in the refund/write off request type) exists for the account. If so, the system considers the unmatched financial transactions of the account and then creates a transfer adjustment against each of them on the netting contract. However, if the netting contract does not exist for the account, then the system does the following:

1. Creates a netting contract using the netting contract type specified in the refund/write off request type

2. Considers the unmatched financial transactions of the account and then creates a transfer adjustment against each of them on the netting contract

You can opt to exclude unmatched financial transactions of contracts created using a particular contract type by setting the Excluded Contract types for netting option type of the C1_​CMO feature configuration. You can exclude multiple contract types by defining the Excluded Contract types for netting option type multiple times (with unique sequence number) in the feature configuration. This option type is considered only when the adjustment level is set to Account.

On submitting or approving a refund/write off request at the account level, the system validates whether the refund/write off amount matches the current account balance. If the refund/write off amount does not match the current account balance, the system does not allow you to process the refund/write off request. However, if the refund/write off amount matches the current account balance, the system creates the transfer adjustments and refund/write off adjustment on the netting contract of the account.

On voiding a refund request where the adjustment level is set to Account, the system cancels the transfer adjustments and refund adjustment on the netting contract of the account. And, on canceling a write off request where the adjustment level is set to Account, the system cancels the transfer adjustments and write off adjustment on the netting contract of the account.