Refund / Write Off Request Errors Out Due To Query Timeout For Request With Large Bill Segments
(Doc ID 2302790.1)

Last updated on SEPTEMBER 01, 2017

Applies to:

Oracle Financial Services Revenue Management and Billing - Version 2.4.0.1.0 and laterInformation in this document applies to any platform.

Symptoms

On : 2.4.0.1.0 version, BI - Billing

ACTUAL BEHAVIOR ---------------On : 2.4.0.1.0 version, BI - Billing

ACTUAL BEHAVIOR ---------------Refund / Write Off request errors out due to query timeout while processing request with large number of Bill segments

Refund / Write Off Requests are erroring out due to Query Timeout since the invoices have a large number of bill segments. Currently the Refund / Write Off request are proceed online once the request is Approved and there is no option to defer the request to batch mode. When an invoice / invoices with large number of Bill Segments is added to the Request to either Refund and Write Off the request times out since there are a large number of transactions being created online. It is a very common scenario to have a Bill over 300 Bill segments being Written Off or being refunded.

Business users have been breaking the Refund / Write Off requests into multiple requests due to the recent performance issues. They tried these scenarios after the application of the recent Performance Fixes and it failed their testing. It is no longer sustainable for them to break the Refunds / Write Offs into multiple Requests due to growing customer base in production due to Migration.

User would need to update the Lifecycle to support Online and Batch modes based on configurable number of Refund / Write Off details.Possible approach would be to add an “Approved – Deferred Processing” status (Non-transitory) and update the Enter algorithm on the Approved status (Transitory) status to transition to this instead of Creating Adjustment when no further approvals are required. This can be subject to configurable count of Refund / Write Off details.

STEPS-----------------------The issue can be reproduced at will with the following steps:- Create a Refund / Write Off request with 500 Bill Segments.- Approve the Refund / Write Off.- The Request Errors out.