You are browsing the archive for Business Intelligence.

PRC: Update Project Performance Data

 

NAME: PRC: Update Project Performance Data
SHORT CODE: PJI_PJP_SUMMARIZE_INCR
MODULE: Oracle Project Intelligence

Description: This process performs incremental updates of project data for Project Performance solution.
Navigation: Oracle Project Intelligence Responsibility -> View -> Requests -> Submit a new request -> Select Single Request -> Click ‘OK’ -> Select Name of concurrent program / report.

Report Parameters:

  • p_run_mode : Specify Incremental Summarization Mode
  • p_operating_unit : Operating Unit
  • p_project_organization_id : Project Organization
  • p_project_type : Project Type
  • p_from_project_id : From Project Number
  • p_to_project_id : To Project Number
  • p_plan_type_id : Plan Type
  • p_rbs_header_id : RBS Header Name
  • p_transaction_type : Transaction Type
  • p_plan_versions : Plan Version
  • p_project_status : Project Status

 

PRC: Load Project Performance Data

 

NAME: PRC: Load Project Performance Data
SHORT CODE: PJI_PJP_SUMMARIZE_FULL
MODULE: Oracle Project Intelligence

Description: This process performs incremental updates of project data for Project Performance solution.
Navigation: Oracle Project Intelligence Responsibility -> View -> Requests -> Submit a new request -> Select Single Request -> Click ‘OK’ -> Select Name of concurrent program / report.

Report Parameters:

  • p_run_type : Specify Full Summarization Mode
  • p_operating_unit : Operating Unit
  • p_project_organization_id : Project Organization
  • p_project_type : Project Type
  • p_from_project_id : From Project Number
  • p_to_project_id : To Project Number
  • p_plan_type_id : Plan Type
  • p_rbs_header_id : RBS Header Name
  • p_transaction_type : Transaction Type
  • p_plan_versions : Plan Version

 

PRC: Launch Update Project Performance Data

 

NAME: PRC: Launch Update Project Performance Data
SHORT CODE: PJI_PJP_LAUNCH_UPP_PRG
MODULE: Oracle Project Intelligence

Description: This process launches PRC: Update Project Performance Data in batches
Navigation: Oracle Project Intelligence Responsibility -> View -> Requests -> Submit a new request -> Select Single Request -> Click ‘OK’ -> Select Name of concurrent program / report.

Report Parameters:

  • P_NUM_OF_PROJECTS : Number of projects
  • P_TEMP_TABLE_SIZE : Number of rows in temporary table
  • P_NUM_PARALLEL_RUNS : Number of parallel runs of UPP process
  • P_NUM_OF_BATCHES : Number of batches
  • P_WAIT_TIME_SECONDS : Wait time in seconds
  • P_REGENERATE_BATCHES : Regenerate Batches
  • P_INCREMENTAL_MODE : Incremental Mode
  • P_OPERATING_UNIT : Operating Unit
  • P_PROJECT_STATUS : Project Status