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

Last updated on MARCH 08, 2017

Applies to:

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

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

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