You are browsing the archive for Business Intelligence.

PRC: Load Project Intelligence Data

 

NAME: PRC: Load Project Intelligence Data
SHORT CODE: PJI_PJI_SUMMARIZE_FULL
MODULE: Oracle Project Intelligence

Description: This process performs incremental updates of project data for Project Intelligence but not Project Performance.
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 summarization mode
  • p_prtl_schedule : Refresh Schedule
  • p_organization : Expenditure Organization (schedule)
  • p_include_sub_org : Include Sub-Organizations (schedule)
  • p_prtl_financial : Refresh Financial
  • p_operating_unit : Project Operating Unit (financial)
  • p_from_project : From Project (financial)
  • p_to_project : To Project (financial)
  • p_plan_type : Plan Type (financial)

 

PRC: Delete Historical Workplans and Financial Plans

 

NAME: PRC: Delete Historical Workplans and Financial Plans
SHORT CODE: PJI_PA_DEL_WP_FP
MODULE: Oracle Project Intelligence

Description: This program deletes historical financial plans and workplans
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_operating_unit : Operating Unit
  • p_from_project : From Project Number
  • p_to_project : To Project Number
  • p_fp_option : Delete Option for Historical Financial Plans
  • p_plan_type : Financial Plan Type
  • p_wp_option : Delete Option for Historical Workplans
  • p_rep_only : Delete Reporting Data Only

 

Materialized View Refresh Utility

 

NAME: Materialized View Refresh Utility
SHORT CODE: PJI_MV_REFRESH
MODULE: Oracle Project Intelligence

Description: Refreshes one or all materialized views
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_name : Materialized View name or `All`