You are browsing the archive for Oracle Project Intelligence.

by oracleguru

Projects Intelligence Tables

ORACLE APPS COMMUNITY > Tutorial > Business Intelligence > Oracle Project Intelligence

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

No Comments »

by oracleguru

Project Intelligence Concurrent Programs

ORACLE APPS COMMUNITY > Tutorial > Business Intelligence > Oracle Project Intelligence

Oracle Project Intelligence Concurrent Programs

CONCURRENT PROGRAM SHORT CODE CONCURRENT PROGRAM NAME
PJI_SUMMARIZE Update Project Intelligence Data
PJI_SETUP_REPORT Project Intelligence Setup Audit Report
PJI_SECURITY_REPORT Project Intelligence Security Audit Report
PJI_SUM_CLEANALL PRC: Delete Project Intelligence and Performance Reporting Data
PJI_EXTRACTION_HELPER Parallel Worker
PJI_RM_SUMMARIZE_UPDATE Update Project Resource Management Data
PJI_RM_SUMMARIZE_REFRESH Refresh Project Resource Management Data
PJI_FM_SUMMARIZE_REFRESH Refresh Project Financial Data
PJI_MV_REFRESH Materialized View Refresh Utility
PJI_RM_WORKER_1 Extract Project Resource Management Data
PJI_FM_WORKER_1 Extract Project Financial Data
PJI_FM_SUMMARIZE_UPDATE Update Project Financial Data
PJI_FM_HELPER_1 PRC: Process Project Financial Data
PJI_RM_HELPER_1 PRC: Process Project Resource Management Data
PJI_FM_SUMMARIZE_FULL PRC: Load Project and Resource Base Summaries
PJI_PJP_SUMMARIZE_FULL PRC: Load Project Performance Data
PJI_FM_SUMMARIZE_INCR PRC: Update Project and Resource Base Summaries
PJI_PJP_SUMMARIZE_INCR PRC: Update Project Performance Data
PJI_FM_SUM_CHANGE Process Project Summary Changes
PJI_FM_SUMMARIZE_PRTL PRC: Refresh Project and Resource Base Summaries
PJI_PJP_SUMMARIZE_PRTL PRC: Refresh Project Performance Data
PJI_PJP_SUMMARIZE_RBS PRC: Process Resource Breakdown Structure Updates
PJI_PJP_SUM_CLEANALL PRC: Delete Project Performance Reporting Data
PJI_PJI_SUMMARIZE_FULL PRC: Load Project Intelligence Data
PJI_PJI_SUMMARIZE_INCR PRC: Update Project Intelligence Data
PJI_PJI_SUM_CLEANALL PRC: Delete Project Intelligence Data
PJI_PJI_SUMMARIZE_PRTL PRC: Refresh Project Intelligence Data
PJI_PJP_SETUP_REPORT AUD: Project Performance Reporting Setup
PJI_PA_DEL_WP_FP PRC: Delete Historical Workplans and Financial Plans
PJI_PJP_LAUNCH_UPP_PRG PRC: Launch Update Project Performance Data

Tags: , No Comments »

by oracleguru

Views in Oracle Projects Intelligence Module

ORACLE APPS COMMUNITY > Tutorial > Business Intelligence > Oracle Project Intelligence

List of views in Oracle Projects Intelligence Module

PJI_AC_ACT_CMT_BY_RSRC_V
PJI_AC_ACT_CMT_BY_TASK_V
PJI_AC_PLN_BY_RSRC_V
PJI_AC_PLN_BY_TASK_V
PJI_AC_XBS_ACCUM_F_V
PJI_ACCUM_RL_ACT_V
PJI_ACCUM_WBS_ACT_V
PJI_ACT_CMT_BY_PERIOD_V
PJI_AVL_DAYS_V
PJI_AVL_THRESHOLDS_V
PJI_AVL_TYPES_V
PJI_CLASS_CATEGORIES_V
PJI_CLASS_CODES_V
PJI_CURRENCY_TYPES_V
PJI_DEFAULT_PERIOD_SETTINGS_V
PJI_DIS_MGRRES_V
PJI_DIS_MGRWT_V
PJI_DIS_ORG_HRCHY_V
PJI_DIS_ORG_ROHRCHY_V
PJI_DIS_ORG_V
PJI_DIS_ORGJOB_V
PJI_DIS_ORGRES_V
PJI_DIS_ORGWT_V
PJI_DIS_PERSON_V
PJI_DIS_RESWT_V
PJI_DIS_SEC_ORG_V
PJI_DIS_SEC_ORGZ_V
PJI_DIS_SUP_HRCHY_V
PJI_DIS_SUP_ROHRCHY_V
PJI_DIS_WORK_TYPES_V
PJI_EXP_CATEGORIES_V
PJI_EXP_EVT_TYPES_V
PJI_EXP_TYPES_V
PJI_FP_XBS_ACCUM_F_V
PJI_JOB_LEVELS_V
PJI_JOBS_V
PJI_LOOKUPS
PJI_MT_MEASURE_SETS_VL
PJI_MT_MEASURES_V
PJI_MT_MEASURES_VL
PJI_MT_ROWSET_VL
PJI_OPERATING_UNITS_V
PJI_ORGANIZATIONS_V
PJI_PERIOD_TYPES_V
PJI_PRD_ACT_CMT_BY_RSRC_V
PJI_PRD_ACT_CMT_BY_TASK_V
PJI_PRD_ACT_CMT_PG_TASK_V
PJI_PRD_PLN_BY_RSRC_V
PJI_PRD_PLN_BY_TASK_V
PJI_PROJECTS_V
PJI_REVENUE_CATEGORIES_V
PJI_TIME_CAL_PERIOD_V
PJI_TIME_CAL_QTR_V
PJI_TIME_CAL_RPT_STRUCT_V
PJI_TIME_CAL_YEAR_V
PJI_TIME_ENT_PERIOD_V
PJI_TIME_ENT_QTR_V
PJI_TIME_ENT_YEAR_V
PJI_TIME_PA_PERIOD_V
PJI_TIME_RPT_STRUCT_V
PJI_TIME_WEEK_V
PJI_UTIL_CATEGORIES_V
PJI_WORK_TYPES_V
PJI_XBS_PLANS_PRJ_V
PJI_XBS_PLANS_V
PJI_XTD_ACT_CMT_BY_RSRC_V
PJI_XTD_ACT_CMT_BY_TASK_V
PJI_XTD_PLN_BY_RSRC_V
PJI_XTD_PLN_BY_TASK_V
PJI_YES_NO_V

Tags: No Comments »