You are browsing the archive for Oracle Project 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

 

Project Intelligence Profile Options

Oracle Project Intelligence Profile Options:

PROFILE OPTION SHORT CODE PROFILE OPTION NAME
PJI_OUTPUT_DESTINATION PJI: PJI Output Destination
PJI_DEF_RPT_CUR_TYPE PJI: Default Reporting Currency Type
PJI_DEF_RPT_CAL_TYPE PJI: Default Reporting Calendar Type
PJI_SUM_CLEANALL PJI: Truncate PJI Summary Tables
PJI_EXTRACTION_PARALLELISM PJI: Number of Parallel Extraction Programs
PJI_USE_DBI_RSG PJI: Use DBI Request Set Generator
PJI_GLOBAL_START_DATE_OVERRIDE PJI: Global Start Date Override (mm/dd/yyyy)
PJI_DEBUG_LEVEL PJI: Debug Level
PJI_DEBUG_MODE PJI: Debug Mode
PJI_SECURITY_PROFILE_LEVEL PJI: Organization Security Profile