Billing Month End Run - Long Running Select
Last updated on OCTOBER 18, 2017
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.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms