My Oracle Support Banner

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 2.4.0.1.0 and later
Information in this document applies to any platform.

Symptoms

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.

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.