R12: Performance Issue While Creating Online Accounting
(Doc ID 2706365.1)
Last updated on OCTOBER 13, 2020
Applies to:Oracle Payables - Version 12.1.3 and later
Oracle 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.
While creating accounting online, a performance issue is occurring. The trace file shows the following SQL is taking a long time:
DELETE /*+ index(dist ZX_REC_NREC_DIST_U3) */ FROM ZX_REC_NREC_DIST DIST
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)
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