My Oracle Support Banner

Upgrade To 12.1.3 - The Script xlaaxuar.sql has Performance Issues (Doc ID 1918275.1)

Last updated on JANUARY 31, 2018

Applies to:

Oracle Receivables - Version 12.1.1 and later
Information in this document applies to any platform.

Symptoms

On : 12.1.1 version, Installation Issues

During the upgrade from 11.5.10 to 12.1.3, the script xlaaxuar.sql is having performance issues.

The following is the SQL statement causing the performance issue:

INSERT /*+ append parallel(xdl1) */ INTO XLA_DISTRIBUTION_LINKS XDL1 (APPLICATION_ID, EVENT_ID, AE_HEADER_ID, AE_LINE_NUM, ACCOUNTING_LINE_CODE, ACCOUNTING_LINE_TYPE_CODE, REF_AE_HEADER_ID, SOURCE_DISTRIBUTION_TYPE, SOURCE_DISTRIBUTION_ID_CHAR_1, SOURCE_DISTRIBUTION_ID_CHAR_2, SOURCE_DISTRIBUTION_ID_CHAR_3, SOURCE_DISTRIBUTION_ID_CHAR_4, SOURCE_DISTRIBUTION_ID_CHAR_5, SOURCE_DISTRIBUTION_ID_NUM_1, SOURCE_DISTRIBUTION_ID_NUM_2, SOURCE_DISTRIBUTION_ID_NUM_3, SOURCE_DISTRIBUTION_ID_NUM_4, SOURCE_DISTRIBUTION_ID_NUM_5, UNROUNDED_ENTERED_DR, UNROUNDED_ENTERED_CR, UNROUNDED_ACCOUNTED_DR, UNROUNDED_ACCOUNTED_CR, MERGE_DUPLICATE_CODE, TAX_LINE_REF_ID, TAX_SUMMARY_LINE_REF_ID, TAX_REC_NREC_DIST_REF_ID, STATISTICAL_AMOUNT, TEMP_LINE_NUM, EVENT_TYPE_CODE, EVENT_CLASS_CODE, REF_EVENT_ID, UPG_BATCH_ID) SELECT XDL.APPLICATION_ID, XDL.EVENT_ID, XAH1.AE_HEADER_ID, XDL.AE_LINE_NUM, XDL.ACCOUNTING_LINE_CODE, XDL.ACCOUNTING_LINE_TYPE_CODE, XDL.REF_AE_HEADER_ID, XDL.S OURCE_DISTRIBUTION_TYPE, XDL.SOURCE_DISTRIBUTION_ID_CHAR_1, XDL.SOURCE_DISTRIBUTION_ID_CHAR_2, XDL.SOURCE_DISTRIBUTION_ID_CHAR_3, XDL.SOURCE_DISTRIBUTION_ID_CHAR_4, XDL.SOURCE_DISTRIBUTION_ID_CHAR_5, XDL.SOURCE_DISTRIBUTION_ID_NUM_1, XDL.SOURCE_DISTRIBUTION_ID_NUM_2, XDL.SOURCE_DISTRIBUTION_ID_NUM_3, XDL.SOURCE_DISTRIBUTION_ID_NUM_4, XDL.SOURCE_DISTRIBUTION_ID_NUM_5, XDL.UNROUNDED_ENTERED_DR, XDL.UNROUNDED_ENTERED_CR, XDL.UNROUNDED_ACCOUNTED_DR, XDL.UNROUNDED_ACCOUNTED_CR, XDL.MERGE_DUPLICATE_CODE, XDL.TAX_LINE_REF_ID, XDL.TAX_SUMMARY_LINE_REF_ID, XDL.TAX_REC_NREC_DIST_REF_ID, XDL.STATISTICAL_AMOUNT, XDL.TEMP_LINE_NUM, XDL.EVENT_TYPE_CODE, XDL.EVENT_CLASS_CODE, XDL.REF_EVENT_ID, XDL.UPG_BATCH_ID FROM XLA_TRANSACTION_ENTITIES_UPG XTE, XLA_EVENTS XE, XLA_AE_HEADERS XAH, XLA_AE_HEADERS XAH1, XLA_DISTRIBUTION_LINKS XDL, GL_LEDGERS GL WHERE XTE.APPLICATION_ID = 222 AND XTE.ENTITY_CODE = 'RECEIPTS' AND XTE.LEDGER_ID = XAH.LEDGER_ID AND XTE.ENTITY_ID = XE.ENTITY_I D AND XE.APPLICATION_ID = 222 AND XE.UPG_BATCH_ID = -5672 AND XE.EVENT_ID = XAH.EVENT_ID AND XAH.APPLICATION_ID = 222 AND XE.EVENT_ID = XAH1.EVENT_ID AND GL.LEDGER_ID=XAH1.LEDGER_ID AND GL.LEDGER_CATEGORY_CODE='SECONDARY' AND XAH1.APPLICATION_ID = 222 AND XAH.LEDGER_ID = XTE.LEDGER_ID AND XAH.AE_HEADER_ID = XDL.AE_HEADER_ID AND XDL.APPLICATION_ID = 222 AND NOT EXISTS (SELECT 1 FROM XLA_DISTRIBUTION_LINKS WHERE APPLICATION_ID = 222 AND AE_HEADER_ID = XAH1.AE_HEADER_ID)

Changes

 

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
 1. Bug Summary
 2. Fixed Files
 3. Recommended Patches
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.