R12 Performance Issue on Export of Project List Page (Doc ID 1595682.1)

Last updated on MARCH 08, 2017

Applies to:

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

Symptoms

Performance issue downloading the Project list to Excel. The problem statements are:

SELECT PJI_REP_OVERVIEW_TYPE( PLAN_VERSION_ID ,PLAN_TYPE_ID ,SUM(PTD_MASK *
 RAW_COST) ,SUM(PTD_MASK * BRDN_COST) ,SUM(PTD_MASK * REVENUE * :B51 ) ,
 SUM(PTD_MASK * BILL_RAW_COST * :B51 ) ,SUM(PTD_MASK * BILL_BRDN_COST * :B51
 ) ,SUM(PTD_MASK * BILLABLE_EQUIPMENT_HOURS * :B51 ) ,SUM(PTD_MASK *
 BILL_LABOR_RAW_COST * :B51 ) ,SUM(PTD_MASK * BILL_LABOR_BRDN_COST * :B51 ) ,
 SUM(PTD_MASK * BILL_LABOR_HRS * :B51 ) ,SUM(PTD_MASK *
 CAPITALIZABLE_RAW_COST * :B52 ) ,SUM(PTD_MASK * CAPITALIZABLE_BRDN_COST *
 :B52 ) ,SUM(PTD_MASK * EQUIPMENT_HOURS) ,SUM(PTD_MASK * EQUIPMENT_RAW_COST)
 ,SUM(PTD_MASK * EQUIPMENT_BRDN_COST) ,SUM(PTD_MASK * LABOR_RAW_COST) ,
 SUM(PTD_MASK * LABOR_BRDN_COST) ,SUM(PTD_MASK * LABOR_HRS) ,SUM(PTD_MASK *
 LABOR_REVENUE * :B51 ) ,SUM(PTD_MASK * 0) ,SUM(PTD_MASK * 0) ,SUM(ITD_MASK
 * SUP_INV_COMMITTED_COST) ,SUM(ITD_MASK * PO_COMMITTED_COST) ,SUM(ITD_MASK
 * PR_COMMITTED_COST) ,SUM(ITD_MASK * OTH_COMMITTED_COST) ,SUM(QTD_MASK *
 RAW_COST) ,SUM(QTD_MASK * BRDN_COST) ,SUM(QTD_MASK * REVENUE * :B51 ) ,
 SUM(QTD_MASK * BILL_RAW_COST * :B51 ) ,SUM(QTD_MASK * BILL_BRDN_COST * :B51
 ) ,SUM(QTD_MASK * BILLABLE_EQUIPMENT_HOURS * :B51 ) ,SUM(QTD_MASK *
 BILL_LABOR_RAW_COST * :B51 ) ,SUM(QTD_MASK * BILL_LABOR_BRDN_COST * :B51 ) ,
 SUM(QTD_MASK * BILL_LABOR_HRS * :B51 ) ,SUM(QTD_MASK *
 CAPITALIZABLE_RAW_COST * :B52 ) ,SUM(QTD_MASK * CAPITALIZABLE_BRDN_COST *
 :B52 ) ,SUM(QTD_MASK * EQUIPMENT_HOURS) ,SUM(QTD_MASK * EQUIPMENT_RAW_COST)
 ,SUM(QTD_MASK * EQUIPMENT_BRDN_COST) ,SUM(QTD_MASK * LABOR_RAW_COST) ,
 SUM(QTD_MASK * LABOR_BRDN_COST) ,SUM(QTD_MASK * LABOR_HRS) ,SUM(QTD_MASK *
 LABOR_REVENUE * :B51 ) ,SUM(QTD_MASK * 0) ,SUM(QTD_MASK * 0) ,SUM(ITD_MASK
 * SUP_INV_COMMITTED_COST) ,SUM(ITD_MASK * PO_COMMITTED_COST) ,SUM(ITD_MASK
 * PR_COMMITTED_COST) ,SUM(ITD_MASK * OTH_COMMITTED_COST) ,SUM(YTD_MASK *
 RAW_COST) ,SUM(YTD_MASK * BRDN_COST) ,SUM(YTD_MASK * REVENUE * :B51 ) ,
 SUM(YTD_MASK * BILL_RAW_COST * :B51 ) ,SUM(YTD_MASK * BILL_BRDN_COST * :B51
 ) ,SUM(YTD_MASK * BILLABLE_EQUIPMENT_HOURS * :B51 ) ,SUM(YTD_MASK *
 BILL_LABOR_RAW_COST * :B51 ) ,SUM(YTD_MASK * BILL_LABOR_BRDN_COST * :B51 ) ,
 SUM(YTD_MASK * BILL_LABOR_HRS * :B51 ) ,SUM(YTD_MASK *
 CAPITALIZABLE_RAW_COST * :B52 ) ,SUM(YTD_MASK * CAPITALIZABLE_BRDN_COST *
 :B52 ) ,SUM(YTD_MASK * EQUIPMENT_HOURS) ,SUM(YTD_MASK * EQUIPMENT_RAW_COST)
 ,SUM(YTD_MASK * EQUIPMENT_BRDN_COST) ,SUM(YTD_MASK * LABOR_RAW_COST) ,
 SUM(YTD_MASK * LABOR_BRDN_COST) ,SUM(YTD_MASK * LABOR_HRS) ,SUM(YTD_MASK *
 LABOR_REVENUE * :B51 ) ,SUM(YTD_MASK * 0) ,SUM(YTD_MASK * 0) ,SUM(ITD_MASK
 * SUP_INV_COMMITTED_COST) ,SUM(ITD_MASK * PO_COMMITTED_COST) ,SUM(ITD_MASK
 * PR_COMMITTED_COST) ,SUM(ITD_MASK * OTH_COMMITTED_COST) ,SUM(ITD_MASK *
 RAW_COST) ,SUM(ITD_MASK * BRDN_COST) ,SUM(ITD_MASK * REVENUE * :B51 ) ,
 SUM(ITD_MASK * BILL_RAW_COST * :B51 ) ,SUM(ITD_MASK * BILL_BRDN_COST * :B51
 ) ,SUM(ITD_MASK * BILLABLE_EQUIPMENT_HOURS * :B51 ) ,SUM(ITD_MASK *
 BILL_LABOR_RAW_COST * :B51 ) ,SUM(ITD_MASK * BILL_LABOR_BRDN_COST * :B51 ) ,
 SUM(ITD_MASK * BILL_LABOR_HRS * :B51 ) ,SUM(ITD_MASK *
 CAPITALIZABLE_RAW_COST * :B52 ) ,SUM(ITD_MASK * CAPITALIZABLE_BRDN_COST *
 :B52 ) ,SUM(ITD_MASK * EQUIPMENT_HOURS) ,SUM(ITD_MASK * EQUIPMENT_RAW_COST)
 ,SUM(ITD_MASK * EQUIPMENT_BRDN_COST) ,SUM(ITD_MASK * LABOR_RAW_COST) ,
 SUM(ITD_MASK * LABOR_BRDN_COST) ,SUM(ITD_MASK * LABOR_HRS) ,SUM(ITD_MASK *
 LABOR_REVENUE * :B51 ) ,SUM(ITD_MASK * 0) ,SUM(ITD_MASK * 0) ,SUM(AC_MASK *
 SUP_INV_COMMITTED_COST) ,SUM(AC_MASK * PO_COMMITTED_COST) ,SUM(AC_MASK *
 PR_COMMITTED_COST) ,SUM(AC_MASK * OTH_COMMITTED_COST) ,SUM(AC_MASK *
 RAW_COST) ,SUM(AC_MASK * BRDN_COST) ,SUM(AC_MASK * REVENUE * :B51 ) ,
 SUM(AC_MASK * BILL_RAW_COST * :B51 ) ,SUM(AC_MASK * BILL_BRDN_COST * :B51 )
 ,SUM(AC_MASK * BILLABLE_EQUIPMENT_HOURS * :B51 ) ,SUM(AC_MASK *
 BILL_LABOR_RAW_COST * :B51 ) ,SUM(AC_MASK * BILL_LABOR_BRDN_COST * :B51 ) ,
 SUM(AC_MASK * BILL_LABOR_HRS * :B51 ) ,SUM(AC_MASK * CAPITALIZABLE_RAW_COST
 * :B52 ) ,SUM(AC_MASK * CAPITALIZABLE_BRDN_COST * :B52 ) ,SUM(AC_MASK *
 EQUIPMENT_HOURS) ,SUM(AC_MASK * EQUIPMENT_RAW_COST) ,SUM(AC_MASK *
 EQUIPMENT_BRDN_COST) ,SUM(AC_MASK * LABOR_RAW_COST) ,SUM(AC_MASK *
 LABOR_BRDN_COST) ,SUM(AC_MASK * LABOR_HRS) ,SUM(AC_MASK * LABOR_REVENUE *
 :B51 ) ,SUM(AC_MASK * 0) ,SUM(AC_MASK * 0) ,SUM(AC_MASK *
 SUP_INV_COMMITTED_COST) ,SUM(AC_MASK * PO_COMMITTED_COST) ,SUM(AC_MASK *
 PR_COMMITTED_COST) ,SUM(AC_MASK * OTH_COMMITTED_COST) ,SUM(PRP_MASK *
 RAW_COST) ,SUM(PRP_MASK * BRDN_COST) ,SUM(PRP_MASK * REVENUE * :B51 ) ,
 SUM(PRP_MASK * BILL_RAW_COST * :B51 ) ,SUM(PRP_MASK * BILL_BRDN_COST * :B51
 ) ,SUM(PRP_MASK * BILLABLE_EQUIPMENT_HOURS * :B51 ) ,SUM(PRP_MASK *
 BILL_LABOR_RAW_COST * :B51 ) ,SUM(PRP_MASK * BILL_LABOR_BRDN_COST * :B51 ) ,
 SUM(PRP_MASK * BILL_LABOR_HRS * :B51 ) ,SUM(PRP_MASK *
 CAPITALIZABLE_RAW_COST * :B52 ) ,SUM(PRP_MASK * CAPITALIZABLE_BRDN_COST *
 :B52 ) ,SUM(PRP_MASK * EQUIPMENT_HOURS) ,SUM(PRP_MASK * EQUIPMENT_RAW_COST)
 ,SUM(PRP_MASK * EQUIPMENT_BRDN_COST) ,SUM(PRP_MASK * LABOR_RAW_COST) ,
 SUM(PRP_MASK * LABOR_BRDN_COST) ,SUM(PRP_MASK * LABOR_HRS) ,SUM(PRP_MASK *
 LABOR_REVENUE * :B51 ) ,SUM(PRP_MASK * 0) ,SUM(PRP_MASK * 0) ,NULL ,NULL ,
 NULL ,NULL ,SUM(PTD_MASK * FCT.CUSTOM1) ,SUM(PTD_MASK * FCT.CUSTOM2) ,
 SUM(PTD_MASK * FCT.CUSTOM3) ,SUM(PTD_MASK * FCT.CUSTOM4) ,SUM(PTD_MASK *
 FCT.CUSTOM5) ,SUM(PTD_MASK * FCT.CUSTOM6) ,SUM(PTD_MASK * FCT.CUSTOM7) ,
 SUM(PTD_MASK * FCT.CUSTOM8) ,SUM(PTD_MASK * FCT.CUSTOM9) ,SUM(PTD_MASK *
 FCT.CUSTOM10) ,SUM(ITD_MASK * FCT.CUSTOM11) ,SUM(ITD_MASK * FCT.CUSTOM12) ,
 SUM(ITD_MASK * FCT.CUSTOM13) ,SUM(ITD_MASK * FCT.CUSTOM14) ,SUM(ITD_MASK *
 FCT.CUSTOM15) ,SUM(PTD_MASK * FCT.CUSTOM16) ,SUM(PTD_MASK * FCT.CUSTOM17) ,
 SUM(PTD_MASK * FCT.CUSTOM18) ,SUM(PTD_MASK * FCT.CUSTOM19) ,SUM(PTD_MASK *
 FCT.CUSTOM20) ,SUM(PTD_MASK * FCT.CUSTOM21) ,SUM(PTD_MASK * FCT.CUSTOM22) ,
 SUM(PTD_MASK * FCT.CUSTOM23) ,SUM(PTD_MASK * FCT.CUSTOM24) ,SUM(PTD_MASK *
 FCT.CUSTOM25) ,SUM(PTD_MASK * FCT.CUSTOM26) ,SUM(PTD_MASK * FCT.CUSTOM27) ,
 SUM(PTD_MASK * FCT.CUSTOM28) ,SUM(PTD_MASK * FCT.CUSTOM29) ,SUM(PTD_MASK *
 FCT.CUSTOM30) ,SUM(QTD_MASK * FCT.CUSTOM1) ,SUM(QTD_MASK * FCT.CUSTOM2) ,
 SUM(QTD_MASK * FCT.CUSTOM3) ,SUM(QTD_MASK * FCT.CUSTOM4) ,SUM(QTD_MASK *
 FCT.CUSTOM5) ,SUM(QTD_MASK * FCT.CUSTOM6) ,SUM(QTD_MASK * FCT.CUSTOM7) ,
 SUM(QTD_MASK * FCT.CUSTOM8) ,SUM(QTD_MASK * FCT.CUSTOM9) ,SUM(QTD_MASK *
 FCT.CUSTOM10) ,SUM(ITD_MASK * FCT.CUSTOM11) ,SUM(ITD_MASK * FCT.CUSTOM12) ,
 SUM(ITD_MASK * FCT.CUSTOM13) ,SUM(ITD_MASK * FCT.CUSTOM14) ,SUM(ITD_MASK *
 FCT.CUSTOM15) ,SUM(QTD_MASK * FCT.CUSTOM16) ,SUM(QTD_MASK * FCT.CUSTOM17) ,
 SUM(QTD_MASK * FCT.CUSTOM18) ,SUM(QTD_MASK * FCT.CUSTOM19) ,SUM(QTD_MASK *
 FCT.CUSTOM20) ,SUM(QTD_MASK * FCT.CUSTOM21) ,SUM(QTD_MASK * FCT.CUSTOM22) ,
 SUM(QTD_MASK * FCT.CUSTOM23) ,SUM(QTD_MASK * FCT.CUSTOM24) ,SUM(QTD_MASK *
 FCT.CUSTOM25) ,SUM(QTD_MASK * FCT.CUSTOM26) ,SUM(QTD_MASK * FCT.CUSTOM27) ,
 SUM(QTD_MASK * FCT.CUSTOM28) ,SUM(QTD_MASK * FCT.CUSTOM29) ,SUM(QTD_MASK *
 FCT.CUSTOM30) ,SUM(YTD_MASK * FCT.CUSTOM1) ,SUM(YTD_MASK * FCT.CUSTOM2) ,
 SUM(YTD_MASK * FCT.CUSTOM3) ,SUM(YTD_MASK * FCT.CUSTOM4) ,SUM(YTD_MASK *
 FCT.CUSTOM5) ,SUM(YTD_MASK * FCT.CUSTOM6) ,SUM(YTD_MASK * FCT.CUSTOM7) ,
 SUM(YTD_MASK * FCT.CUSTOM8) ,SUM(YTD_MASK * FCT.CUSTOM9) ,SUM(YTD_MASK *
 FCT.CUSTOM10) ,SUM(ITD_MASK * FCT.CUSTOM11) ,SUM(ITD_MASK * FCT.CUSTOM12) ,
 SUM(ITD_MASK * FCT.CUSTOM13) ,SUM(ITD_MASK * FCT.CUSTOM14) ,SUM(ITD_MASK *
 FCT.CUSTOM15) ,SUM(YTD_MASK * FCT.CUSTOM16) ,SUM(YTD_MASK * FCT.CUSTOM17) ,
 SUM(YTD_MASK * FCT.CUSTOM18) ,SUM(YTD_MASK * FCT.CUSTOM19) ,SUM(YTD_MASK *
 FCT.CUSTOM20) ,SUM(YTD_MASK * FCT.CUSTOM21) ,SUM(YTD_MASK * FCT.CUSTOM22) ,
 SUM(YTD_MASK * FCT.CUSTOM23) ,SUM(YTD_MASK * FCT.CUSTOM24) ,SUM(YTD_MASK *
 FCT.CUSTOM25) ,SUM(YTD_MASK * FCT.CUSTOM26) ,SUM(YTD_MASK * FCT.CUSTOM27) ,
 SUM(YTD_MASK * FCT.CUSTOM28) ,SUM(YTD_MASK * FCT.CUSTOM29) ,SUM(YTD_MASK *
 FCT.CUSTOM30) ,SUM(ITD_MASK * FCT.CUSTOM1) ,SUM(ITD_MASK * FCT.CUSTOM2) ,
 SUM(ITD_MASK * FCT.CUSTOM3) ,SUM(ITD_MASK * FCT.CUSTOM4) ,SUM(ITD_MASK *
 FCT.CUSTOM5) ,SUM(ITD_MASK * FCT.CUSTOM6) ,SUM(ITD_MASK * FCT.CUSTOM7) ,
 SUM(ITD_MASK * FCT.CUSTOM8) ,SUM(ITD_MASK * FCT.CUSTOM9) ,SUM(ITD_MASK *
 FCT.CUSTOM10) ,SUM(AC_MASK * FCT.CUSTOM11) ,SUM(AC_MASK * FCT.CUSTOM12) ,
 SUM(AC_MASK * FCT.CUSTOM13) ,SUM(AC_MASK * FCT.CUSTOM14) ,SUM(AC_MASK *
 FCT.CUSTOM15) ,SUM(ITD_MASK * FCT.CUSTOM16) ,SUM(ITD_MASK * FCT.CUSTOM17) ,
 SUM(ITD_MASK * FCT.CUSTOM18) ,SUM(ITD_MASK * FCT.CUSTOM19) ,SUM(ITD_MASK *
 FCT.CUSTOM20) ,SUM(ITD_MASK * FCT.CUSTOM21) ,SUM(ITD_MASK * FCT.CUSTOM22) ,
 SUM(ITD_MASK * FCT.CUSTOM23) ,SUM(ITD_MASK * FCT.CUSTOM24) ,SUM(ITD_MASK *
 FCT.CUSTOM25) ,SUM(ITD_MASK * FCT.CUSTOM26) ,SUM(ITD_MASK * FCT.CUSTOM27) ,
 SUM(ITD_MASK * FCT.CUSTOM28) ,SUM(ITD_MASK * FCT.CUSTOM29) ,SUM(ITD_MASK *
 FCT.CUSTOM30) ,SUM(AC_MASK * FCT.CUSTOM1) ,SUM(AC_MASK * FCT.CUSTOM2) ,
 SUM(AC_MASK * FCT.CUSTOM3) ,SUM(AC_MASK * FCT.CUSTOM4) ,SUM(AC_MASK *
 FCT.CUSTOM5) ,SUM(AC_MASK * FCT.CUSTOM6) ,SUM(AC_MASK * FCT.CUSTOM7) ,
 SUM(AC_MASK * FCT.CUSTOM8) ,SUM(AC_MASK * FCT.CUSTOM9) ,SUM(AC_MASK *
 FCT.CUSTOM10) ,SUM(AC_MASK * FCT.CUSTOM11) ,SUM(AC_MASK * FCT.CUSTOM12) ,
 SUM(AC_MASK * FCT.CUSTOM13) ,SUM(AC_MASK * FCT.CUSTOM14) ,SUM(AC_MASK *
 FCT.CUSTOM15) ,SUM(AC_MASK * FCT.CUSTOM16) ,SUM(AC_MASK * FCT.CUSTOM17) ,
 SUM(AC_MASK * FCT.CUSTOM18) ,SUM(AC_MASK * FCT.CUSTOM19) ,SUM(AC_MASK *
 FCT.CUSTOM20) ,SUM(AC_MASK * FCT.CUSTOM21) ,SUM(AC_MASK * FCT.CUSTOM22) ,
 SUM(AC_MASK * FCT.CUSTOM23) ,SUM(AC_MASK * FCT.CUSTOM24) ,SUM(AC_MASK *
 FCT.CUSTOM25) ,SUM(AC_MASK * FCT.CUSTOM26) ,SUM(AC_MASK * FCT.CUSTOM27) ,
 SUM(AC_MASK * FCT.CUSTOM28) ,SUM(AC_MASK * FCT.CUSTOM29) ,SUM(AC_MASK *
 FCT.CUSTOM30) ,SUM(PRP_MASK * FCT.CUSTOM1) ,SUM(PRP_MASK * FCT.CUSTOM2) ,
 SUM(PRP_MASK * FCT.CUSTOM3) ,SUM(PRP_MASK * FCT.CUSTOM4) ,SUM(PRP_MASK *
 FCT.CUSTOM5) ,SUM(PRP_MASK * FCT.CUSTOM6) ,SUM(PRP_MASK * FCT.CUSTOM7) ,
 SUM(PRP_MASK * FCT.CUSTOM8) ,SUM(PRP_MASK * FCT.CUSTOM9) ,SUM(PRP_MASK *
 FCT.CUSTOM10) ,SUM(PRP_MASK * FCT.CUSTOM11) ,SUM(PRP_MASK * FCT.CUSTOM12) ,
 SUM(PRP_MASK * FCT.CUSTOM13) ,SUM(PRP_MASK * FCT.CUSTOM14) ,SUM(PRP_MASK *
 FCT.CUSTOM15) ,SUM(PRP_MASK * FCT.CUSTOM16) ,SUM(PRP_MASK * FCT.CUSTOM17) ,
 SUM(PRP_MASK * FCT.CUSTOM18) ,SUM(PRP_MASK * FCT.CUSTOM19) ,SUM(PRP_MASK *
 FCT.CUSTOM20) ,SUM(PRP_MASK * FCT.CUSTOM21) ,SUM(PRP_MASK * FCT.CUSTOM22) ,
 SUM(PRP_MASK * FCT.CUSTOM23) ,SUM(PRP_MASK * FCT.CUSTOM24) ,SUM(PRP_MASK *
 FCT.CUSTOM25) ,SUM(PRP_MASK * FCT.CUSTOM26) ,SUM(PRP_MASK * FCT.CUSTOM27) ,
 SUM(PRP_MASK * FCT.CUSTOM28) ,SUM(PRP_MASK * FCT.CUSTOM29) ,SUM(PRP_MASK *
 FCT.CUSTOM30) )
FROM
PJI_FP_XBS_ACCUM_F_V FCT , (SELECT TIME_ID, PERIOD_TYPE_ID, :B2
 CALENDAR_TYPE ,SIGN(BITAND(RECORD_TYPE_ID,:B10 )) PTD_MASK ,
 SIGN(BITAND(RECORD_TYPE_ID,:B9 )) QTD_MASK ,SIGN(BITAND(RECORD_TYPE_ID,:B8 )
 ) YTD_MASK ,SIGN(BITAND(RECORD_TYPE_ID,:B7 )) ITD_MASK ,0 AC_MASK ,0
 PRP_MASK FROM PJI_TIME_CAL_RPT_STRUCT WHERE 1=1 AND BITAND(RECORD_TYPE_ID,
 :B6 ) = RECORD_TYPE_ID AND CALENDAR_ID = :B5 AND REPORT_DATE = TO_DATE(:B4 ,
 :B3 ) AND :B2 <> :B1 UNION ALL SELECT TIME_ID, PERIOD_TYPE_ID, :B2
 CALENDAR_TYPE ,SIGN(BITAND(RECORD_TYPE_ID,:B10 )) PTD_MASK ,
 SIGN(BITAND(RECORD_TYPE_ID,:B9 )) QTD_MASK ,SIGN(BITAND(RECORD_TYPE_ID,:B8 )
 ) YTD_MASK ,SIGN(BITAND(RECORD_TYPE_ID,:B7 )) ITD_MASK ,0 AC_MASK ,0
 PRP_MASK FROM PJI_TIME_RPT_STRUCT WHERE 1=1 AND BITAND(RECORD_TYPE_ID,:B6 )
 = RECORD_TYPE_ID AND REPORT_DATE = TO_DATE(:B4 ,:B3 ) AND :B2 = :B1 UNION
 ALL SELECT -1 TIME_ID, 2048 PERIOD_TYPE_ID, :B11 CALENDAR_TYPE ,0 PTD_MASK ,
 0 QTD_MASK ,0 YTD_MASK ,0 ITD_MASK ,1 AC_MASK ,0 PRP_MASK FROM DUAL UNION
 ALL SELECT CAL_PERIOD_ID TIME_ID, 32 PERIOD_TYPE_ID, :B2 CALENDAR_TYPE ,0
 PTD_MASK ,0 QTD_MASK ,0 YTD_MASK ,0 ITD_MASK ,0 AC_MASK ,1 PRP_MASK FROM
 PJI_TIME_CAL_PERIOD_V WHERE 1=1 AND TO_DATE(:B4 ,:B3 )-1 BETWEEN START_DATE
 AND END_DATE AND CALENDAR_ID = :B5 AND :B2 <> :B1 UNION ALL SELECT
 ENT_PERIOD_ID TIME_ID, 32 PERIOD_TYPE_ID, :B2 CALENDAR_TYPE ,0 PTD_MASK ,0
 QTD_MASK ,0 YTD_MASK ,0 ITD_MASK ,0 AC_MASK ,1 PRP_MASK FROM
 PJI_TIME_ENT_PERIOD_V WHERE 1=1 AND TO_DATE(:B4 ,:B3 )-1 BETWEEN START_DATE
 AND END_DATE AND :B2 = :B1 ) TIME WHERE 1=1 AND FCT.PRG_ROLLUP_FLAG IN
 (:B50 ,:B49 ) AND ( (:B46 = :B48 AND FCT.RBS_AGGR_LEVEL = :B47 ) OR ((:B46
 IN (:B45 , :B44 , :B43 )) AND (FCT.RBS_AGGR_LEVEL IN (:B42 , :B41 ))) ) AND
 FCT.WBS_ROLLUP_FLAG IN (:B40 , :B39 ) AND FCT.PROJECT_ID = :B38 AND
 FCT.PROJECT_ELEMENT_ID = :B37 AND FCT.RBS_VERSION_ID = :B36 AND
 FCT.RBS_ELEMENT_ID = :B35 AND FCT.CURRENCY_CODE = :B34 AND
 BITAND(FCT.CURR_RECORD_TYPE_ID,:B33 ) = :B33 AND FCT.PERIOD_TYPE_ID =
 TIME.PERIOD_TYPE_ID AND FCT.TIME_ID = TIME.TIME_ID AND (FCT.CALENDAR_TYPE =
 TIME.CALENDAR_TYPE OR TIME.CALENDAR_TYPE = :B11 ) AND FCT.PLAN_VERSION_ID
 IN ( :B32 , :B31 , :B30 , :B29 , :B28 , :B27 , :B26 , :B25 , :B24 , :B23 ,
 :B22 , :B21 , :B20 , :B19 , :B18 , DECODE(FCT.PRG_ROLLUP_FLAG, 'Y', -3,-99)
 , DECODE(FCT.PRG_ROLLUP_FLAG, 'Y', -4,-99) ) AND FCT.PLAN_TYPE_ID IN ( -1 ,
 :B17 , :B16 , :B15 , :B14 , :B13 , :B12 ) GROUP BY PLAN_VERSION_ID,
 FCT.PLAN_TYPE_ID

and

BEGIN PJI_REP_MEASURE_UTIL.Get_Financial_Measures_wrp(p_project_id_tbl
  => :1, p_measure_codes_tbl => :2, p_measure_set_codes_tbl
  => :3, p_timeslices_tbl => :4, p_measure_id_tbl
  => :5, x_measure_values_tbl => :6, x_exception_indicator_tbl
 => :7, x_return_status => :8, x_msg_count =
 > :9, x_msg_data => :10); END;


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