My Oracle Support Banner

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

Last updated on NOVEMBER 06, 2018

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

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
References


This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process and therefore has not been subject to an independent technical review.
My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.