Billing Month End Run - Long Running Select
(Doc ID 2318853.1)
Last updated on MARCH 19, 2019
Applies to:Oracle Financial Services Revenue Management and Billing - Version 220.127.116.11.0 and later
Information in this document applies to any platform.
Billing month end run - Long running Select
The SQL in question runs throughout the billing run. From the comment at the end of SQL and is generated from the Cobol component of the product.
/* SQL for COBOL program 'CIPBSPCX', SQL name 'S_NEWBC' */
The issue is with the use of ROWNUM=1 and order by clause and that sometimes the SQL can take up to 10-15 sec.
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