Hold Refund

Oracle Revenue Management and Billing enables you to hold the refund process for an account through a hold request. If the refund process is kept on hold for an account, the system does not process the refund requests (if any) created for the account. Note that the system does not stop you from creating A/P adjustments for an account from the Adjustment screen when the refund process is kept on hold for the account.

While adding the refund process in a hold request, you need to specify the date range for which you want to hold the refund process for the accounts. The system enables you to hold the refund process by creating a hold request from the user interface or through the upload request feature. If you want to create a hold request to hold the refund process for an account through the upload request feature, you need to specify the following details in the CSV file:

• Whether you want to hold the refund process for the account (the valid values are Y or N)

• Hold refund start date (required if the hold refund is set to Y)

• Hold refund end date

You can also create, update, or release a hold request through an inbound web service. For more information, see Hold Request Creation, Modification, Release, and View Through Inbound Web Service.

Refund Hold Activation

On activating a hold request for an account, the system sets the hold refund until date corresponding to the accounts whose date range falls within the refund process date range of the hold request. The hold refund until date is set to the hold entity end date or refund process end date whichever is earlier. This means that the system will allow to process the refund request for the accounts only after the respective hold refund until date. Note that if the start date of the hold request, hold entity, or hold process is earlier than the system date, the system sets the respective start date to the system date.

Let us understand how the hold refund until date is derived for an account that is kept on hold through a hold request.

In the scenario 1, the hold refund until date for the Account 1 is set to 15-Jan-2025 and the hold refund until date for the Account 2 is set to 20-Jan-2025. This is because the entity end date is earlier than the refund process end date. However, in the scenario 2, the hold refund until date for the Account 1 is set to 20-Jan-2025. This is because the refund process end date is earlier than the entity end date.

In the scenario 3, three hold requests are created with different hold reasons to keep the Account 3 on hold for different duration. In this case, the hold refund until date of the Account 3 is updated every time a new hold request is created for the same account. On 1st Jan, the hold refund until date of the Account 3 is set to 15-Jan-2025 and then on 5th Jan, the hold refund until date of the Account 3 is updated to 20-Jan-2025, and finally, on 10th Jan, the hold refund until date of the Account 3 is updated to 25-Jan-2025.

In the scenario 4, the hold refund until date for the Account 1 and Account 2 is set to 30-Jan-2025. This is because the system sets the hold refund until date to the refund process end date when the entity end date is not specified in the hold request. In the scenario 5, the hold refund until date for the Account 1 and Account 2 is set to 31-Jan-2025. This is because the system sets the hold refund until date to hold request end date when both the entity end date and refund process end date are not specified in the hold request. In the scenario 6, the hold refund until date for the Account 1 and Account 2 is set to 15-Jan-2025 and 20-Jan-2025, respectively.

In all the above scenarios, the start date of the hold request, hold process, and hold entity is same. Therefore, the hold refund until date is derived for the entities either immediately or in the deferred mode (when the C1-HLDRQ batch is executed). However, if the start date of the refund process or hold entity is later than the hold request start date, the hold refund until date is derived for the respective entity in the deferred mode (when the C1-HLMON batch is executed on or after refund process or hold entity start date). For example,

In the scenario 1, the hold refund until date for the Account 1 is derived on 01-Jan-2025 (in the online mode), or on or after 01-Jan-2025 (in the deferred mode). However, the hold refund until date for the Account 2 is derived on or after 05-Jan-2025 (in the deferred mode). Similarly, in the scenario 2, the hold refund until date for the Account 1 is derived on or after 15-Mar-2025 (in the deferred mode) and not on 01-Mar-2025.

If the number of accounts in the hold request is less than or equal to the defer processing count (specified in the respective hold request type), the system immediately sets the hold refund until date for the respective accounts. In addition, the system changes the status of the non-final refund request (if any) for the respective accounts to Hold. However, if the number of accounts in the hold request is greater than the defer processing count, the system sets the hold refund until date for the respective accounts in the deferred mode when the C1-HLDRQ batch is executed. In addition, the C1-HLDRQ batch changes the status of the non-final refund request (if any) for the respective accounts to Hold.

Refund Hold Release

On releasing a hold request for an account, the system sets the hold refund until date to the system date for the respective accounts. Let us understand how the hold refund until date is updated for an account when the hold is manually or automatically released.

In the scenario 1, the hold refund until date for the Account 1 and Account 2 is set to the system date when the hold request is manually released on 10-Jan-2025. In the scenario 2, the hold refund until date for the Account 1 is set to the batch business date (i.e., 20-Jan-2025) when the hold request is automatically released through the C1-HLMON batch.

In the scenario 3, the hold refund until date for the Account 3 is not set to the system date when the hold request 2 and 3 are manually released on 10-Jan-2025 and 20-Jan-2025, respectively. The hold refund until date for the Account 3 is set to the system date when the hold request 4 is manually released on 21-Jan-2025. This is because no more hold requests exist for the Account 3 in the system.

If the number of accounts in the hold request is less than the defer processing count (specified in the respective hold request type), the system immediately sets the hold refund until date to the system date for the respective accounts. In addition, the system immediately changes the status of the refund request (if any) for the respective accounts from Hold to its previous status. However, if the number of accounts in the hold request is greater than the defer processing count, the system sets the hold refund until date to the system date for the respective accounts in the deferred mode when the C1-HLMON batch is executed. In addition, the C1-HLMON batch changes the status of the refund request (if any) for the respective accounts from Hold to its previous status.