R12: Performance Issue While Creating Online Accounting
(Doc ID 2706365.1)
Last updated on APRIL 20, 2023
Applies to:
Oracle Payables - Version 12.1.3 and laterOracle E-Business Tax - Version 12.1.3 and later
Oracle Receivables - Version 12.1.3 and later
Information in this document applies to any platform.
Symptoms
While creating accounting online, a performance issue is occurring. The trace file shows the following SQL is taking a long time:
SQL ID: 1usu7fhyudbgs Plan Hash: 1129789980
DELETE /*+ index(dist ZX_REC_NREC_DIST_U3) */ FROM ZX_REC_NREC_DIST DIST
WHERE
DIST.APPLICATION_ID = :B3 AND DIST.ENTITY_CODE = :B2 AND
DIST.EVENT_CLASS_CODE = :B1 AND DIST.TRX_ID IN (SELECT /*+
use_hash(ZX_LINES_DET_FACTORS) */ TRX_ID FROM ZX_LINES_DET_FACTORS WHERE
APPLICATION_ID = :B3 AND ENTITY_CODE = :B2 AND EVENT_CLASS_CODE = :B1 AND
EVENT_ID = :B4 ) AND DIST.TAX_LINE_ID NOT IN (SELECT TAX_LINE_ID FROM
ZX_LINES LINE WHERE LINE.APPLICATION_ID = DIST.APPLICATION_ID AND
LINE.ENTITY_CODE = DIST.ENTITY_CODE AND LINE.EVENT_CLASS_CODE =
DIST.EVENT_CLASS_CODE AND LINE.TRX_ID = DIST.TRX_ID)
DELETE /*+ index(dist ZX_REC_NREC_DIST_U3) */ FROM ZX_REC_NREC_DIST DIST
WHERE
DIST.APPLICATION_ID = :B3 AND DIST.ENTITY_CODE = :B2 AND
DIST.EVENT_CLASS_CODE = :B1 AND DIST.TRX_ID IN (SELECT /*+
use_hash(ZX_LINES_DET_FACTORS) */ TRX_ID FROM ZX_LINES_DET_FACTORS WHERE
APPLICATION_ID = :B3 AND ENTITY_CODE = :B2 AND EVENT_CLASS_CODE = :B1 AND
EVENT_ID = :B4 ) AND DIST.TAX_LINE_ID NOT IN (SELECT TAX_LINE_ID FROM
ZX_LINES LINE WHERE LINE.APPLICATION_ID = DIST.APPLICATION_ID AND
LINE.ENTITY_CODE = DIST.ENTITY_CODE AND LINE.EVENT_CLASS_CODE =
DIST.EVENT_CLASS_CODE AND LINE.TRX_ID = DIST.TRX_ID)
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 |