R12 Performance Issue With PAXACMPT PRC: Update Project Summary Accounts Jobs During Commitment (Doc ID 1997874.1)

Last updated on NOVEMBER 16, 2022

Applies to:

Symptoms

On : 12.1.3 version, Project Performance Reporting

ACTUAL BEHAVIOR
---------------
The PAXACMPT - PRC: Update Project Summary Amounts process is slow. The most expensive query is:

INSERT INTO PA_PJM_REQ_COMMITMENTS_TMP ( PROJECT_ID ,TASK_ID ,REQ_NUMBER ,REQ_DISTRIBUTION_ID ,REQUISITION_HEADER_ID ,ITEM_DESCRIPTION ,EXPENDITURE_ITEM_DATE ,REQ_LINE ,CREATION_DATE ,REQUESTOR_NAME ,APPROVED_FLAG ,NEED_BY_DATE ,EXPENDITURE_ORGANIZATION_ID ,VENDOR_ID ,VENDOR_NAME ,EXPENDITURE_TYPE ,EXPENDITURE_CATEGORY ,REVENUE_CATEGORY ,UNIT_OF_MEASURE ,UNIT_PRICE ,AMOUNT ,QUANTITY ,DENOM_CURRENCY_CODE ,DENOM_AMOUNT ,ACCT_CURRENCY_CODE ,ACCT_RATE_DATE ,ACCT_RATE_TYPE ,ACCT_EXCHANGE_RATE ,INVENTORY_ITEM_ID ,INVENTORY_ITEM_NAME ,UOM_CODE ,WIP_RESOURCE_ID ,WIP_RESOURCE_NAME ) SELECT /*+ leading(prj) */ PMPRD.PROJECT_ID ,PMPRD.TASK_ID ,PMPRD.REQ_NUMBER ,PMPRD.REQ_DISTRIBUTION_ID ,PMPRD.REQUISITION_HEADER_ID ,PMPRD.ITEM_DESCRIPTION ,PMPRD.EXPENDITURE_ITEM_DATE ,PMPRD.REQ_LINE ,PMPRD.CREATION_DATE ,PMPRD.REQUESTOR_NAME ,PMPRD.APPROVED_FLAG ,PMPRD.NEED_BY_DATE ,PMPRD.EXPENDITURE_ORGANIZATION_ID ,PMPRD.VENDOR_ID ,PMPRD.VENDOR_NAME ,PMPRD.EXPENDITURE_TYPE ,PMPRD.EXPENDITURE_CATEGORY ,PMPRD.REVENUE_CATEGORY ,PMPRD.UNIT_OF_MEASURE ,PMPRD.UNIT_PRICE ,PMPRD.AMOUNT ,PMPRD.QUANTITY ,PMPRD.DENOM_CURRENCY_CODE ,PMPRD.DENOM_AMOUNT ,PMPRD.ACCT_CURRENCY_CODE ,PMPRD.ACCT_RATE_DATE ,PMPRD.ACCT_RATE_TYPE ,PMPRD.ACCT_EXCHANGE_RATE ,PMPRD.INVENTORY_ITEM_ID ,PMPRD.INVENTORY_ITEM_NAME ,PMPRD.UOM_CODE ,PMPRD.WIP_RESOURCE_ID ,PMPRD.WIP_RESOURCE_NAME FROM PJM_REQ_COMMITMENTS_V PMPRD ,PA_PROJ_SUMM_TMP1 PRJ WHERE PMPRD.PROJECT_ID = PRJ.PROJECT_ID

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.