Billing Month End Run - Long Running Select

(Doc ID 2318853.1)

Last updated on OCTOBER 18, 2017

Applies to:

Oracle Financial Services Revenue Management and Billing - Version 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