My Oracle Support Banner

One Of The Base Sql Is Running Slow And Thats Part Of POSTPROC Final Execution (Doc ID 2581525.1)

Last updated on FEBRUARY 03, 2022

Applies to:

Oracle Financial Services Revenue Management and Billing - Version 2.6.0.1.0 and later
Information in this document applies to any platform.

Symptoms

On : 2.6.0.1.0 version, BT - Batch

ACTUAL BEHAVIOR
---------------

The following base SQL statement. which is part of the POSTPROC final execution,  is running slow. 

SELECT DISTINCT SETTLEMENT_ACCT_ID FROM ( SELECT SETTLEMENT_ACCT_ID FROM CI_ADJ AD WHERE AD.SETTLEMENT_ID_NBR = :1 UNION SELECT SETTLEMENT_ACCT_ID FROM CI_BSEG_EXT BE WHERE BE.SETTLEMENT_ID_NBR = :2 ) /* SQL for program 'com.splwg.ccb.domain.billing.common.ProgramCIPBAPAY_Impl', SQL name 'S_BSADSETT' */

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.