You are browsing the archive for Oracle Project Intelligence.

Project Intelligence Profile Options

Oracle Project Intelligence Profile Options:

PROFILE OPTION SHORT CODEPROFILE OPTION NAME
PJI_OUTPUT_DESTINATIONPJI: PJI Output Destination
PJI_DEF_RPT_CUR_TYPEPJI: Default Reporting Currency Type
PJI_DEF_RPT_CAL_TYPEPJI: Default Reporting Calendar Type
PJI_SUM_CLEANALLPJI: Truncate PJI Summary Tables
PJI_EXTRACTION_PARALLELISMPJI: Number of Parallel Extraction Programs
PJI_USE_DBI_RSGPJI: Use DBI Request Set Generator
PJI_GLOBAL_START_DATE_OVERRIDEPJI: Global Start Date Override (mm/dd/yyyy)
PJI_DEBUG_LEVELPJI: Debug Level
PJI_DEBUG_MODEPJI: Debug Mode
PJI_SECURITY_PROFILE_LEVELPJI: Organization Security Profile

Projects Intelligence Tables

Oracle Projects Intelligence Tables:

  • PJI_AC_AGGR_PJP0
  • PJI_AC_AGGR_PJP1
  • PJI_AC_CLSO_F_MV
  • PJI_AC_CLS_F_MV
  • PJI_AC_CUST_PJP0
  • PJI_AC_ORGO_F_MV
  • PJI_AC_ORG_F_MV
  • PJI_AC_PROJ_F
  • PJI_AC_RMAP_ACR
  • PJI_AC_TXN_ACCUM
  • PJI_AC_XBS_ACCUM_F
  • PJI_AV_ORGO_F_MV
  • PJI_AV_ORG_F
  • PJI_CA_ORGO_F_MV
  • PJI_CA_ORG_F
  • PJI_CLASS_CATEGORIES
  • PJI_CLASS_CODES
  • PJI_FM_AGGR_ACT1
  • PJI_FM_AGGR_ACT2
  • PJI_FM_AGGR_ACT3
  • PJI_FM_AGGR_ACT4
  • PJI_FM_AGGR_ACT5
  • PJI_FM_AGGR_ACT_BATCHES
  • PJI_FM_AGGR_DLY_RATES
  • PJI_FM_AGGR_FIN1
  • PJI_FM_AGGR_FIN2
  • PJI_FM_AGGR_FIN3
  • PJI_FM_AGGR_FIN4
  • PJI_FM_AGGR_FIN5
  • PJI_FM_AGGR_FIN6
  • PJI_FM_AGGR_FIN7
  • PJI_FM_AGGR_FIN8
  • PJI_FM_AGGR_FIN9
  • PJI_FM_AGGR_FIN_BATCHES
  • PJI_FM_AGGR_PLN
  • PJI_FM_AGGR_RES_BATCHES
  • PJI_FM_AGGR_RES_TYPES
  • PJI_FM_DNGL_ACT
  • PJI_FM_DNGL_FIN
  • PJI_FM_EXTR_ARINV
  • PJI_FM_EXTR_DINVC
  • PJI_FM_EXTR_DINVCITM
  • PJI_FM_EXTR_DREVN
  • PJI_FM_EXTR_FUNDG
  • PJI_FM_EXTR_PLAN
  • PJI_FM_EXTR_PLAN_LINES
  • PJI_FM_EXTR_PLAN_LINES_DEBUG
  • PJI_FM_EXTR_PLN
  • PJI_FM_EXTR_PLNVER1
  • PJI_FM_EXTR_PLNVER2
  • PJI_FM_EXTR_PLNVER4
  • PJI_FM_EXTR_PLN_LOG
  • PJI_FM_PROJ_BATCH_MAP
  • PJI_FM_PROJ_BATCH_STAT
  • PJI_FM_REXT_CDL
  • PJI_FM_REXT_CRDL
  • PJI_FM_REXT_ERDL
  • PJI_FM_RMAP_ACT
  • PJI_FM_RMAP_FIN
  • PJI_FM_RMAP_PSI
  • PJI_FM_XBS_ACCUM_TMP1_DEBUG
  • PJI_FP_AGGR_PJP0
  • PJI_FP_AGGR_PJP1
  • PJI_FP_AGGR_PJP1_T
  • PJI_FP_AGGR_RBS
  • PJI_FP_AGGR_XBS
  • PJI_FP_CLSO_ET_F_MV
  • PJI_FP_CLSO_ET_WT_F_MV
  • PJI_FP_CLSO_F_MV
  • PJI_FP_CLS_ET_F_MV
  • PJI_FP_CLS_ET_WT_F_MV
  • PJI_FP_CLS_F_MV
  • PJI_FP_CUST_PJP0
  • PJI_FP_ORGO_ET_F_MV
  • PJI_FP_ORGO_ET_WT_F_MV
  • PJI_FP_ORGO_F_MV
  • PJI_FP_ORG_ET_F_MV
  • PJI_FP_ORG_ET_WT_F_MV
  • PJI_FP_ORG_F_MV
  • PJI_FP_PROJ_ET_F
  • PJI_FP_PROJ_ET_WT_F
  • PJI_FP_PROJ_F
  • PJI_FP_RMAP_FPR
  • PJI_FP_TXN_ACCUM
  • PJI_FP_TXN_ACCUM1
  • PJI_FP_TXN_ACCUM_HEADER
  • PJI_FP_XBS_ACCUM_F
  • PJI_HELPER_BATCH_MAP
  • PJI_MT_BUCKETS
  • PJI_MT_MEASURES_B
  • PJI_MT_MEASURES_TL
  • PJI_MT_MEASURE_SETS_B
  • PJI_MT_MEASURE_SETS_TL
  • PJI_MT_PRC_STEPS
  • PJI_MT_ROWSET_B
  • PJI_MT_ROWSET_DET
  • PJI_MT_ROWSET_TL
  • PJI_ORG_DENORM
  • PJI_ORG_EXTR_INFO
  • PJI_ORG_EXTR_STATUS
  • PJI_PA_PROJ_EVENTS_LOG
  • PJI_PJI_PROJ_BATCH_MAP
  • PJI_PJI_PROJ_EXTR_STATUS
  • PJI_PJI_RMAP_ACT
  • PJI_PJI_RMAP_FIN
  • PJI_PJI_RMAP_RES
  • PJI_PJP_PROJ_BATCH_MAP
  • PJI_PJP_PROJ_EXTR_STATUS
  • PJI_PJP_RBS_HEADER
  • PJI_PJP_RMAP_ACR
  • PJI_PJP_RMAP_FPR
  • PJI_PJP_WBS_HEADER
  • PJI_PJ_EXTR_PRJCLS
  • PJI_PMV_CLS_DIM_TMP
  • PJI_PMV_EC_RC_DIM_TMP
  • PJI_PMV_ET_RT_DIM_TMP
  • PJI_PMV_ITD_DIM_TMP
  • PJI_PMV_JB_DIM_TMP
  • PJI_PMV_JL_DIM_TMP
  • PJI_PMV_ORGZ_DIM_TMP
  • PJI_PMV_ORG_DIM_TMP
  • PJI_PMV_PRJ_DIM_TMP
  • PJI_PMV_RC_DIM_TMP
  • PJI_PMV_RT_DIM_TMP
  • PJI_PMV_TCMP_DIM_TMP
  • PJI_PMV_TIME_DIM_TMP
  • PJI_PMV_UC_DIM_TMP
  • PJI_PMV_WT_DIM_TMP
  • PJI_PROJECT_CLASSES
  • PJI_PROJ_EXTR_STATUS
  • PJI_RBS_DENORM
  • PJI_RBS_DENORM_DELTA
  • PJI_REP_XBS_DENORM
  • PJI_RESOURCES_DENORM
  • PJI_RES_DELTA
  • PJI_RES_UTILZ_TMP1
  • PJI_RES_UTILZ_TMP2
  • PJI_RES_UTILZ_TMP3
  • PJI_RM_AGGR_AVL1
  • PJI_RM_AGGR_AVL2
  • PJI_RM_AGGR_AVL3
  • PJI_RM_AGGR_AVL4
  • PJI_RM_AGGR_AVL5
  • PJI_RM_AGGR_RES1
  • PJI_RM_AGGR_RES2
  • PJI_RM_AGGR_RES3
  • PJI_RM_AGGR_RES6
  • PJI_RM_AGGR_RES_BATCHES
  • PJI_RM_DNGL_RES
  • PJI_RM_JOBO_F_MV
  • PJI_RM_JOB_F_MV
  • PJI_RM_ORGO_F_MV
  • PJI_RM_ORG_BATCH_MAP
  • PJI_RM_ORG_BATCH_STAT
  • PJI_RM_ORG_F_MV
  • PJI_RM_RES_BATCH_MAP
  • PJI_RM_RES_F
  • PJI_RM_RES_WT_F
  • PJI_RM_REXT_FCSTITEM
  • PJI_RM_WORK_TYPE_INFO
  • PJI_RM_WORK_TYPE_ROWID
  • PJI_RM_WTO_F_MV
  • PJI_RM_WT_F_MV
  • PJI_ROLLUP_LEVEL_STATUS
  • PJI_ROLL_WEEK_OFFSET
  • PJI_SYSTEM_CONFIG_HIST
  • PJI_SYSTEM_DEBUG_MSG
  • PJI_SYSTEM_PARAMETERS
  • PJI_SYSTEM_PRC_STATUS
  • PJI_SYSTEM_SETTINGS
  • PJI_TIME_CAL_EXTR_INFO
  • PJI_TIME_CAL_PERIOD
  • PJI_TIME_CAL_QTR
  • PJI_TIME_CAL_RPT_STRUCT
  • PJI_TIME_CAL_YEAR
  • PJI_TIME_DAY_MV
  • PJI_TIME_ENT_PERIOD
  • PJI_TIME_ENT_QTR
  • PJI_TIME_ENT_YEAR
  • PJI_TIME_MV
  • PJI_TIME_PA_RPT_STR_MV
  • PJI_TIME_RPT_STRUCT
  • PJI_TIME_TREND_MV
  • PJI_TIME_WEEK
  • PJI_XBS_DENORM
  • PJI_XBS_DENORM_DELTA

Project Intelligence Concurrent Programs

Oracle Project Intelligence Concurrent Programs

CONCURRENT PROGRAM SHORT CODECONCURRENT PROGRAM NAME
PJI_SUMMARIZEUpdate Project Intelligence Data
PJI_SETUP_REPORTProject Intelligence Setup Audit Report
PJI_SECURITY_REPORTProject Intelligence Security Audit Report
PJI_SUM_CLEANALLPRC: Delete Project Intelligence and Performance Reporting Data
PJI_EXTRACTION_HELPERParallel Worker
PJI_RM_SUMMARIZE_UPDATEUpdate Project Resource Management Data
PJI_RM_SUMMARIZE_REFRESHRefresh Project Resource Management Data
PJI_FM_SUMMARIZE_REFRESHRefresh Project Financial Data
PJI_MV_REFRESHMaterialized View Refresh Utility
PJI_RM_WORKER_1Extract Project Resource Management Data
PJI_FM_WORKER_1Extract Project Financial Data
PJI_FM_SUMMARIZE_UPDATEUpdate Project Financial Data
PJI_FM_HELPER_1PRC: Process Project Financial Data
PJI_RM_HELPER_1PRC: Process Project Resource Management Data
PJI_FM_SUMMARIZE_FULLPRC: Load Project and Resource Base Summaries
PJI_PJP_SUMMARIZE_FULLPRC: Load Project Performance Data
PJI_FM_SUMMARIZE_INCRPRC: Update Project and Resource Base Summaries
PJI_PJP_SUMMARIZE_INCRPRC: Update Project Performance Data
PJI_FM_SUM_CHANGEProcess Project Summary Changes
PJI_FM_SUMMARIZE_PRTLPRC: Refresh Project and Resource Base Summaries
PJI_PJP_SUMMARIZE_PRTLPRC: Refresh Project Performance Data
PJI_PJP_SUMMARIZE_RBSPRC: Process Resource Breakdown Structure Updates
PJI_PJP_SUM_CLEANALLPRC: Delete Project Performance Reporting Data
PJI_PJI_SUMMARIZE_FULLPRC: Load Project Intelligence Data
PJI_PJI_SUMMARIZE_INCRPRC: Update Project Intelligence Data
PJI_PJI_SUM_CLEANALLPRC: Delete Project Intelligence Data
PJI_PJI_SUMMARIZE_PRTLPRC: Refresh Project Intelligence Data
PJI_PJP_SETUP_REPORTAUD: Project Performance Reporting Setup
PJI_PA_DEL_WP_FPPRC: Delete Historical Workplans and Financial Plans
PJI_PJP_LAUNCH_UPP_PRGPRC: Launch Update Project Performance Data