Performance Issue When Changing Classification Tax in Purchase Order Manage Tax Form

(Doc ID 2048057.1)

Last updated on DECEMBER 28, 2017

Applies to:

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

Symptoms

Using Oracle Purchasing module, when changing classification on the Manage Tax framework page it is taking a very long time.


Replication Steps:
1. Login to the E-Business Suite and choose the Purchasing Module.
    May use core form or Buyers WorkCenter
2. Proceed to the purchase order form - then manage tax.
3. Choose and change tax classification - and Apply.


From the raw trace file:

UPDATE PO_DISTRIBUTIONS_ALL PD SET PD.RECOVERABLE_TAX = (SELECT
SUM(ZXDIST.REC_NREC_TAX_AMT) FROM ZX_REC_NREC_DIST ZXDIST
WHERE
ZXDIST.TRX_LINE_DIST_ID = PD.PO_DISTRIBUTION_ID AND ZXDIST.RECOVERABLE_FLAG =
'Y' AND ZXDIST.APPLICATION_ID = :B3 AND ZXDIST.ENTITY_CODE = :B2 AND
ZXDIST.EVENT_CLASS_CODE = :B1 ) ,PD.NONRECOVERABLE_TAX = (SELECT
SUM(ZXDIST.REC_NREC_TAX_AMT) FROM ZX_REC_NREC_DIST ZXDIST WHERE
ZXDIST.TRX_LINE_DIST_ID = PD.PO_DISTRIBUTION_ID AND ZXDIST.RECOVERABLE_FLAG
= 'N' AND ZXDIST.APPLICATION_ID = :B3 AND ZXDIST.ENTITY_CODE = :B2 AND
ZXDIST.EVENT_CLASS_CODE = :B1 ), LAST_UPDATE_DATE = SYSDATE,
LAST_UPDATED_BY = FND_GLOBAL.USER_ID, LAST_UPDATE_LOGIN =
FND_GLOBAL.LOGIN_ID WHERE PD.PO_DISTRIBUTION_ID IN (SELECT TRX_LINE_DIST_ID
FROM ZX_ITM_DISTRIBUTIONS_GT)

call count cpu elapsed disk query current rows
------- ------ -------- ---------- ---------- ---------- ---------- ----------
Parse 1 0.00 0.00 0 0 0 0
Execute 1 22.77 173.50 171035 342087 8 1
Fetch 0 0.00 0.00 0 0 0 0
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total 2 22.77 173.51 171035 342087 8 1

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