Hold Overdue Process

Oracle Revenue Management and Billing enables you to hold the overdue process for an account through a hold request. If the overdue process is kept on hold for an account, the system does not allow you to initiate an overdue process for the account. In addition, if an active overdue process (if any) exists for the account kept on hold, the system cancels the respective overdue process of the account and changes its status to Inactive.

While adding the overdue process in a hold request, you need to specify the date range for which you want to hold the overdue process for the accounts. The system enables you to hold the overdue 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 overdue 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 overdue process for the account (the valid values are Y or N)

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

• Hold overdue 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.

Overdue Hold Activation

On activating a hold request for an account, the system sets the postpone credit review until date corresponding to the accounts whose date range falls within the overdue process date range of the hold request. The postpone credit review until date is set to the hold entity end date or overdue process end date whichever is earlier. This means that the system will allow to initiate an overdue process for the account only after the respective postpone credit review 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 postpone credit review until date is derived for an account that is kept on hold through a hold request.

In the scenario 1, the postpone credit review until date for the Account 1 is set to 15-Jan-2025 and the postpone credit review until date for the Account 2 is set to 20-Jan-2025. This is because the entity end date is earlier than the overdue process end date. However, in the scenario 2, the postpone credit review until date for the Account 1 is set to 20-Jan-2025. This is because the overdue 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 postpone credit review until date of the Account 3 is updated every time a new hold request is created for the same account. On 1st Jan, the postpone credit review until date of the Account 3 is set to 15-Jan-2025 and then on 5th Jan, the postpone credit review until date of the Account 3 is updated to 20-Jan-2025, and finally, on 10th Jan, the postpone credit review until date of the Account 3 is updated to 25-Jan-2025.

In the scenario 4, the postpone credit review until date for the Account 1 and Account 2 is set to 30-Jan-2025. This is because the system sets the postpone credit review until date to the overdue process end date when the entity end date is not specified in the hold request. In the scenario 5, the postpone credit review until date for the Account 1 and Account 2 is set to 31-Jan-2025. This is because the system sets the postpone credit review until date to hold request end date when both the entity end date and overdue process end date are not specified in the hold request. In the scenario 6, the postpone credit review 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 postpone credit review 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 overdue process or hold entity is later than the hold request start date, the postpone credit review until date is derived for the respective entity in the deferred mode (when the C1-HLMON batch is executed on or after the overdue process or hold entity start date). For example,

In the scenario 1, the postpone credit review 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 postpone credit review until date for the Account 2 is derived on or after 05-Jan-2025 (in the deferred mode). Similarly, in the scenario 2, the postpone credit review 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 postpone credit review until date for the respective accounts. However, if the number of accounts in the hold request is greater than the defer processing count, the system sets the postpone credit review until date for the respective accounts in the deferred mode when the C1-HLDRQ batch is executed.

Overdue Hold Release

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

In the scenario 1, the postpone credit review 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 postpone credit review 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 postpone credit review 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 postpone credit review 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 or equal to the defer processing count (specified in the respective hold request type), the system immediately sets the postpone credit review until date to the system date for the respective accounts. However, if the number of accounts in the hold request is greater than the defer processing count, the system sets the postpone credit review until date to the system date for the respective accounts in the deferred mode when the C1-HLMON batch is executed.