My Oracle Support Banner

PJI_PJP_SUMMARIZE_INCR PRC: Update Project Performance Data Performance Issue (Doc ID 2562565.1)

Last updated on JANUARY 03, 2021

Applies to:

Oracle Project Planning and Control - Version 12.2.7 to 12.2.8 [Release 12.2]
Information in this document applies to any platform.

Symptoms

 PJI_PJP_SUMMARIZE_INCR PRC:Update Project Performance Data performance issue 

 

Below is the costly query causing the issueL


INSERT INTO PJI_AC_AGGR_PJP1 PJP1_I ( WORKER_ID, RECORD_TYPE, PRG_LEVEL,
PROJECT_ID, PROJECT_ORG_ID, PROJECT_ORGANIZATION_ID, PROJECT_ELEMENT_ID,
TIME_ID, PERIOD_TYPE_ID, CALENDAR_TYPE, WBS_ROLLUP_FLAG, PRG_ROLLUP_FLAG,
CURR_RECORD_TYPE_ID, CURRENCY_CODE, REVENUE, INITIAL_FUNDING_AMOUNT,
INITIAL_FUNDING_COUNT, ADDITIONAL_FUNDING_AMOUNT, ADDITIONAL_FUNDING_COUNT,

CANCELLED_FUNDING_AMOUNT, CANCELLED_FUNDING_COUNT,
FUNDING_ADJUSTMENT_AMOUNT, FUNDING_ADJUSTMENT_COUNT, REVENUE_WRITEOFF,
AR_INVOICE_AMOUNT, AR_INVOICE_COUNT, AR_CASH_APPLIED_AMOUNT,
AR_INVOICE_WRITE_OFF_AMOUNT, AR_INVOICE_WRITEOFF_COUNT,
AR_CREDIT_MEMO_AMOUNT, AR_CREDIT_MEMO_COUNT, UNBILLED_RECEIVABLES,
UNEARNED_REVENUE, AR_UNAPPR_INVOICE_AMOUNT, AR_UNAPPR_INVOICE_COUNT,
AR_APPR_INVOICE_AMOUNT, AR_APPR_INVOICE_COUNT, AR_AMOUNT_DUE, AR_COUNT_DUE,

AR_AMOUNT_OVERDUE, AR_COUNT_OVERDUE, CUSTOM1, CUSTOM2, CUSTOM3, CUSTOM4,
CUSTOM5, CUSTOM6, CUSTOM7, CUSTOM8, CUSTOM9, CUSTOM10, CUSTOM11, CUSTOM12,
CUSTOM13, CUSTOM14, CUSTOM15 ) SELECT WORKER_ID, NULL RECORD_TYPE, 0
PRG_LEVEL, PROJECT_ID, PROJECT_ORG_ID, PROJECT_ORGANIZATION_ID,
PROJECT_ELEMENT_ID, TIME_ID, PERIOD_TYPE_ID, CALENDAR_TYPE,

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

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