My Oracle Support Banner

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.

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)

 

 

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


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