My Oracle Support Banner

R12: CE: Performance Issue With Script 'ce11704499.sql' When Applying 12.2.14 Release Pack (Doc ID 3074224.1)

Last updated on MARCH 03, 2025

Applies to:

Oracle Cash Management - Version 12.2.14 to 12.2.14 [Release 12.2]
Information in this document applies to any platform.

Symptoms

When applying Patch 36026788 [ORACLE E-BUSINESS SUITE 12.2.14 RELEASE UPDATE PACK] the worker appears stuck on SQL file 'ce11704499.sql' for several hours.

sqlplus -s APPS/***** @/oracle/R122/fs1/EBSapps/appl/ad/12.0.0/patch/115/sql/adsqlwrapper.sql '/oracle/R122/fs1/EBSapps/appl/ce/12.0.0/patch/115/sql/ce11704499.sql '
Connected.
 
SQL Text is as follows:

SQL Text
------------------------------
UPDATE CE_STATEMENT_RECONCILS_ALL A SET CURRENT_RECORD_FLAG ='Y', CREATED_BY = -500 WHERE ROWID IN ( SELECT ROWID FROM (SELECT ROWID, ROW_NUMBER() OVER (PARTITION BY REFERENCE_TYPE, REFERENCE_ID, JE_HEADER_ID ORDET(*) OVER (PARTITION BY REFERENCE_TYPE, REFERENCE_ID, JE_HEADER_ID ) CN FROM CE_STATEMENT_RECONCILS_ALL A WHERE A.CURRENT_RECORD_FLAG ='N' ) WHERE RN = CN AND RN > 1 ) AND NOT EXISTS (SELECT 'x' FROM CE_STATEMENT_ENCE_ID =
A.REFERENCE_ID AND B.REFERENCE_TYPE = A.REFERENCE_TYPE AND NVL(B.JE_HEADER_ID,0) = NVL(A.JE_HEADER_ID,0) AND B.CURRENT_RECORD_FLAG ='Y' ) RETURNING REFERENCE_ID, REFERENCE_TYPE, JE_HEADER_ID INTO :O0 ,:O1 ,:O2



STEPS
-----------------------
The issue can be reproduced at will with the following steps:

  1.  Apply Patch 36026788 [ORACLE E-BUSINESS SUITE 12.2.14 RELEASE UPDATE PACK]
  2.  Note that the patch appears to hang for hours on this SQL file.



Changes

 Upgrading to Oracle E-Business Suite 12.2.14.

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