Performance Issue When Changing Classification Tax in Purchase Order Manage Tax Form (Doc ID 2048057.1)

Last updated on OCTOBER 25, 2015

Applies to:

Oracle Purchasing - Version 12.1.3 to 12.2.4 [Release 12.1 to 12.2]
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.


Steps to Reproduce :
------------------------
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.

This statement is taking a long time :

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)



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