PAXACMPT, PRC: Update Project Summary Amounts Takes 5 Hours To Complete (Doc ID 1606290.1)

Last updated on MARCH 08, 2017

Applies to:

Oracle Project Planning and Control - Version 12.1.3 and later
Information in this document applies to any platform.

Symptoms

PAXACMPT, Update Project Summary Amounts Performance issue.

SELECT 'Y'
FROM
DUAL WHERE EXISTS ( SELECT REQUISITION_HEADER_ID, LINE_NUM, DISTRIBUTION_ID
 FROM ( SELECT RL.REQUISITION_HEADER_ID, RL.LINE_NUM, RD.DISTRIBUTION_ID
 FROM PO_REQ_DISTRIBUTIONS_ALL RD , PO_REQUISITION_LINES_ALL RL ,
 PJM_ORG_PARAMETERS POP , MTL_SYSTEM_ITEMS MSI , MTL_UNITS_OF_MEASURE_VL UOM
 WHERE RL.DESTINATION_TYPE_CODE = 'INVENTORY' AND RL.REQUISITION_LINE_ID =
 RD.REQUISITION_LINE_ID AND RD.PROJECT_ID IS NULL AND POP.COMMON_PROJECT_ID =
  :B2 AND POP.ORGANIZATION_ID = :B1 AND POP.ORGANIZATION_ID =
 RL.DESTINATION_ORGANIZATION_ID AND MSI.ORGANIZATION_ID =
 RL.DESTINATION_ORGANIZATION_ID AND MSI.INVENTORY_ITEM_ID = RL.ITEM_ID AND
 UOM.UOM_CODE = MSI.PRIMARY_UOM_CODE UNION ALL SELECT
 RL.REQUISITION_HEADER_ID, RL.LINE_NUM, RD.DISTRIBUTION_ID FROM
 PO_REQ_DISTRIBUTIONS_ALL RD , PO_REQUISITION_LINES_ALL RL ,
 PJM_ORG_PARAMETERS POP , WIP_DISCRETE_JOBS WDJ , WIP_OPERATIONS WO ,
 BOM_DEPARTMENTS BD , MTL_UNITS_OF_MEASURE_VL UOM WHERE
 RL.DESTINATION_TYPE_CODE = 'SHOP FLOOR' AND RL.REQUISITION_LINE_ID =
 RD.REQUISITION_LINE_ID AND RD.PROJECT_ID IS NULL AND POP.COMMON_PROJECT_ID =
  :B2 AND RL.DESTINATION_ORGANIZATION_ID = :B1 AND POP.ORGANIZATION_ID =
 RL.DESTINATION_ORGANIZATION_ID AND WDJ.ORGANIZATION_ID =
 RL.DESTINATION_ORGANIZATION_ID AND WDJ.WIP_ENTITY_ID = RL.WIP_ENTITY_ID AND
 WO.ORGANIZATION_ID = WDJ.ORGANIZATION_ID AND WO.WIP_ENTITY_ID =
 WDJ.WIP_ENTITY_ID AND WO.OPERATION_SEQ_NUM = RL.WIP_OPERATION_SEQ_NUM AND
 BD.DEPARTMENT_ID = WO.DEPARTMENT_ID AND UOM.UNIT_OF_MEASURE =
 RL.UNIT_MEAS_LOOKUP_CODE) WHERE NOT EXISTS ( SELECT '2' FROM
 PA_COMMITMENT_TXNS CMT WHERE CMT.LINE_TYPE = 'R' AND CMT.PROJECT_ID = :B2
 AND CMT.BURDEN_SUM_DEST_RUN_ID IS NULL AND CMT.TRANSACTION_SOURCE =
 'ORACLE_PURCHASING' AND CMT.CMT_HEADER_ID = REQUISITION_HEADER_ID AND
 CMT.CMT_LINE_NUMBER = LINE_NUM AND CMT.CMT_DISTRIBUTION_ID =
 DISTRIBUTION_ID ) )


call count cpu elapsed disk query current rows
------- ------ -------- ---------- ---------- ---------- ---------- ----------
Parse 1 0.00 0.00 0 0 0 0
Execute 57 28.77 147.02 146151 648820 0 0
Fetch 57 0.00 0.00 0 0 0 13
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total 115 28.77 147.02 146151 648820 0 13

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