You are browsing the archive for Business Intelligence.

PRC: Delete Project Performance Reporting Data

 

NAME: PRC: Delete Project Performance Reporting Data
SHORT CODE: PJI_PJP_SUM_CLEANALL
MODULE: Oracle Project Intelligence

Description: Truncates all data related to Project Performance. This is a utility program that may be useful in cases of data corruption, hardware failures etc.
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_check : Are you sure?
  • p_fpm_upgrade : Load Financial Plan Summaries

 

PRC: Process Resource Breakdown Structure Updates

 

NAME: PRC: Process Resource Breakdown Structure Updates
SHORT CODE: PJI_PJP_SUMMARIZE_RBS
MODULE: Oracle Project Intelligence

Description: This program updates resource breakdown structures mapping and data for summarization, budgets and allocations. The program also updates RBS assignments.
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 RBS Changes Summarization Mode
  • p_operating_unit : Operating Unit
  • p_project_organization_id : Project Organization
  • p_project_type : Project Type
  • p_from_project_id : From Project
  • p_to_project_id : To Project
  • p_plan_type_id : Plan Type
  • p_rbs_header_id : RBS Header Name

 

PRC: Refresh Project Performance Data

 

NAME: PRC: Refresh Project Performance Data
SHORT CODE: PJI_PJP_SUMMARIZE_PRTL
MODULE: Oracle Project Intelligence

Description: This process performs a complete or partial refresh of project performance data, replacing current data in summary tables.
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 Partial Refresh 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 Versions