You are browsing the archive for Business Intelligence.

PRC: Load Project and Resource Base Summaries

 

NAME: PRC: Load Project and Resource Base Summaries
SHORT CODE: PJI_FM_SUMMARIZE_FULL
MODULE: Oracle Project Intelligence

Description: This process performs initial loading of projects data till the base summary levels (Projects Accum 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 Full Summarization Mode
  • p_extract_commitments : Extract Commitments Data
  • p_organization : Expenditure Organization
  • p_include_sub_org : Include Sub-Organizations
  • p_operating_unit : Operating Unit
  • p_from_project_id : From Project Number
  • p_to_project_id : To Project Number
  • p_plan_type : Plan Type

 

PRC: Process Project Financial Data

 

NAME: PRC: Process Project Financial Data
SHORT CODE: PJI_FM_HELPER_1
MODULE: Oracle Project Intelligence

Description: Internal program used to aid Project Intelligence extraction.
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_worker_id : Worker

 

Update Contract Territories Base Summary Sub Worker

 

NAME: Update Contract Territories Base Summary Sub Worker
SHORT CODE: OKI_TERR_WORKER
MODULE: Oracle Contracts Intelligence

Description: Update Contract Territories Base Summary Sub Worker for Service Contracts Intelligence
Navigation: Oracle Contracts Intelligence Responsibility -> View -> Requests -> Submit a new request -> Select Single Request -> Click ‘OK’ -> Select Name of concurrent program / report.

Report Parameters:

  • p_worker_no : Worker Number