My Oracle Support Banner

Performance Issue with C1-OFSRQ Offset Processing (Doc ID 2580989.1)

Last updated on SEPTEMBER 19, 2019

Applies to:

Oracle Financial Services Revenue Management and Billing - Version 2.6.0.1.0 and later
Information in this document applies to any platform.

Symptoms

On RMB v2.6.0.1.0 against FW v4.3.0.4, Performance issue with C1-OFSRQ Offset Processing

ACTUAL BEHAVIOR
--------------------------------
We are experiencing the Offset Request periodic monitor (C1-OFSRQ) job performance issue. A single request is not completing even after running this job for 7-8 hours.
Offset request is created to create an auto adjustment to apply the credit of one account to close other Open Invoice of the customers. Offset request is moved to ‘Deferred Processing’ state to process the request through batch mode.

EXPECTED BEHAVIOR
-------------------------------------
The Offset Request periodic monitor (C1-OFSRQ) batch should be complete without any performance issue.

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Execute Offset Request periodic monitor (C1-OFSRQ) batch with large number of bill segments like create bill having 5000 bill segments.

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot use C1-OFSRQ batch effectively.

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.