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 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.

Changes

 

Cause

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