Autoinvoice Import Program Performing Slow (Doc ID 2005693.1)

Last updated on JULY 24, 2017

Applies to:

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

Symptoms

On : 12.1.3 version,

Autoinvoice Import Program is performing slow: it takes 25-30 minutes to complete.

A full table scan on table ZX.ZX_LINES_DET_FACTORS was noticed in customer environment.

Poor performance for an update statement
 
UPDATE ZX_LINES_DET_FACTORS ZXLD SET ZXLD.TAX_INVOICE_DATE = (SELECT
 TRXD.GL_DATE FROM RA_CUST_TRX_LINE_GL_DIST_ALL TRXD
WHERE
TRXD.REQUEST_ID=:B2 AND TRXD.ORG_ID= :B1 AND TRXD.CUSTOMER_TRX_ID=
 ZXLD.TRX_ID AND TRXD.CUSTOMER_TRX_LINE_ID = ZXLD.TRX_LINE_ID AND
 ZXLD.APPLICATION_ID=222 AND ZXLD.TAX_INVOICE_DATE IS NULL AND ROWNUM=1)
 WHERE EXISTS (SELECT 1 FROM RA_CUST_TRX_LINE_GL_DIST_ALL TRXD1 WHERE
 TRXD1.REQUEST_ID=:B2 AND TRXD1.ORG_ID= :B1 AND TRXD1.CUSTOMER_TRX_ID=
 ZXLD.TRX_ID AND TRXD1.CUSTOMER_TRX_LINE_ID = ZXLD.TRX_LINE_ID AND
 ZXLD.APPLICATION_ID=222 AND ZXLD.TAX_INVOICE_DATE IS NULL AND ROWNUM=1)


call count cpu elapsed disk query current rows
------- ------ -------- ---------- ---------- ---------- ---------- ----------
Parse 1 0.00 0.00 0 0 0 0
Execute 1 593.17 596.64 5372628 221815193 540 175
Fetch 0 0.00 0.00 0 0 0 0
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total 2 593.17 596.64 5372628 221815193 540 175

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms