PJI Tables (105)
PJI - Project Intelligence(Obsolete) — documented tables from Oracle EBS ETRM 12.2.2. Click any name for its documentation, columns and AI summary.
| Table | Columns | Description |
|---|---|---|
PJI_AC_AGGR_PJP0 |
44 | |
PJI_AC_AGGR_PJP1 |
62 | |
PJI_AC_CUST_PJP0 |
27 | |
PJI_AC_RMAP_ACR |
3 | |
PJI_AC_XBS_ACCUM_F |
63 | This table stores summarized booking and backlog activity measures for project performance by work breakdown and program hierarchies |
PJI_BATCH_STATUS_420 |
4 | This is a temporary table that is used when helper batches are spawned for step 420. This is a persistent table. |
PJI_FM_AGGR_ACT1 |
74 | This is an intermediate summarization table. |
PJI_FM_AGGR_ACT2 |
151 | This is an intermediate summarization table. |
PJI_FM_AGGR_ACT4 |
105 | This intermediate table stages data between PJI and Project Performance summarization. |
PJI_FM_AGGR_DLY_RATES |
7 | This intermediate table contains PJI currency conversion rates during a summarization run. |
PJI_FM_AGGR_FIN1 |
69 | This intermediate table contains PJI summarization data during a summarization run. |
PJI_FM_AGGR_FIN2 |
159 | This intermediate table contains PJI summarization data during a summarization run. |
PJI_FM_AGGR_FIN6 |
97 | This intermediate table is used for the first aggregation of PJP data by periods. |
PJI_FM_AGGR_FIN7 |
76 | This intermediate table is used for staging data between PJI and PJP summarization runs. |
PJI_FM_AGGR_FIN8 |
76 | This intermediate table is used for staging data between PJI and PJP summarization runs. |
PJI_FM_AGGR_RES_TYPES |
2 | This intermediate table is used to look up Resource Class. |
PJI_FM_DNGL_ACT |
151 | This is an intermediate summarization table. |
PJI_FM_DNGL_FIN |
173 | This intermediate table contains dangling PJI summarization data between summarization runs. |
PJI_FM_EXTR_ARINV |
14 | This is an intermediate summarization table. |
PJI_FM_EXTR_DINVC |
22 | This is an intermediate summarization table. |
PJI_FM_EXTR_DINVCITM |
27 | This is an intermediate summarization table. |
PJI_FM_EXTR_DREVN |
19 | This is an intermediate summarization table. |
PJI_FM_EXTR_FUNDG |
12 | This is an intermediate summarization table. |
PJI_FM_EXTR_PLAN |
21 | |
PJI_FM_EXTR_PLAN_LINES |
47 | This table stores the changes to financial plan data |
PJI_FM_EXTR_PLAN_LINES_DEBUG |
47 | This table stores the changes to financial plan data |
PJI_FM_EXTR_PLNVER1 |
12 | This is an intermediate summarization table. |
PJI_FM_EXTR_PLNVER2 |
10 | This is an intermediate summarization table. |
PJI_FM_EXTR_PLNVER4 |
18 | |
PJI_FM_PROJ_BATCH_MAP |
43 | This is an intermediate summarization table. |
PJI_FM_PROJ_BATCH_STAT |
6 | |
PJI_FM_REXT_CDL |
9 | This is an intermediate summarization table. |
PJI_FM_REXT_CRDL |
12 | This is an intermediate summarization table. |
PJI_FM_REXT_ERDL |
21 | This is an intermediate summarization table. |
PJI_FM_RMAP_ACT |
5 | This is an intermediate summarization table. |
PJI_FM_RMAP_FIN |
6 | This is an intermediate summarization table. |
PJI_FM_RMAP_PSI |
5 | |
PJI_FM_XBS_ACCUM_INT |
161 | |
PJI_FM_XBS_ACCUM_TMP1_DEBUG |
119 | |
PJI_FM_XBS_ACCUM_TMP4 |
163 | |
PJI_FP_AGGR_PJP0 |
40 | |
PJI_FP_AGGR_PJP1 |
79 | This table is a mirror of PJI_FP_XBS_ACCUM_FROM used during summarization |
PJI_FP_AGGR_PJP1_T |
79 | This table is a mirror of PJI_FP_XBS_ACCUM_FROM used during summarization |
PJI_FP_AGGR_PJP2 |
79 | This table is a mirror of PJI_FP_AGGR_PJP1 used during summarization |
PJI_FP_AGGR_RBS |
10 | |
PJI_FP_AGGR_RBS_T |
10 | This table is used to build the RBS normalized table |
PJI_FP_AGGR_XBS |
18 | |
PJI_FP_CUST_PJP0 |
33 | |
PJI_FP_RMAP_FPR |
3 | |
PJI_FP_TXN_ACCUM |
59 | This table stores summarized cost and revenue measures at project, task and periodic levels for project performance |
PJI_FP_TXN_ACCUM1 |
39 | This table stores summarized commitment measures at project, task and periodic levels for project performance |
PJI_FP_TXN_ACCUM_HEADER |
34 | This table stores the resource attribute combinations which are used for resource breakdown structure mapping |
PJI_FP_XBS_ACCUM_F |
76 | This table stores summarized cost, revenue, commitments measures for project performance by work breakdown, resource breakdown and program h |
PJI_HELPER_420 |
6 | This is an temporary table that is used to spawn helper batches for step 420. This is a persistent table. |
PJI_HELPER_BATCH_MAP |
3 | This is an intermediate summarization table. |
PJI_MT_BUCKETS |
12 | Information for bucket values for different measures. |
PJI_MT_MEASURES_B |
12 | This table stores the definition of the measures used for reporting in oracle projects. |
PJI_MT_MEASURES_TL |
11 | This table stores translated measure definition. |
PJI_MT_MEASURE_SETS_B |
13 | This table stores information about measure sets used for reporting in Oracle Projects. |
PJI_MT_MEASURE_SETS_TL |
11 | This table stores translated measure set definition. |
PJI_MT_PRC_STEPS |
8 | Information for process steps submitted during summarization. |
PJI_MT_ROWSET_B |
8 | This table stores the measures defined for a row set. |
PJI_MT_ROWSET_DET |
10 | This table stores the measures defined for a row set |
PJI_MT_ROWSET_TL |
11 | This table stores translated measure set definition |
PJI_ORG_EXTR_INFO |
21 | Information for organizations that have been extracted to project performance-reporting model. |
PJI_ORG_EXTR_STATUS |
4 | Extraction status for organizations that have been extracted to project performance-reporting model. |
PJI_PA_PROJ_EVENTS_LOG |
33 | This table is used to take a snapshot of online events. |
PJI_PA_XBS_DENORM_T |
20 | This is an temporary table that is used to store XBS denorm data by the Refresh/Update Project Performance Data. This is a global temporary |
PJI_PJP_PROJ_BATCH_MAP |
12 | This table stores PJP summarization state. |
PJI_PJP_PROJ_EXTR_STATUS |
10 | This table stores PJP summarization state. |
PJI_PJP_RBS_HEADER |
12 | This table tracks associations between project, plan and Resource Breakdown Structures |
PJI_PJP_RMAP_ACR |
2 | |
PJI_PJP_RMAP_FPR |
4 | |
PJI_PJP_WBS_HEADER |
16 | This table tracks associations between projects and Work Breakdown Structures. |
PJI_PJP_WBS_HEADER_T |
16 | This is an temporary table that is used to store temporary data required for WBS Rollup by the Refresh/Update Project Performance Data. This |
PJI_PLAN_EXTR_TMP |
17 | |
PJI_PROJ_EXTR_STATUS |
17 | Extraction status for projects that have been extracted to project performance-reporting model. |
PJI_RBS_DENORM |
12 | This table stores normalized resource breakdown structure information |
PJI_RBS_DENORM_DELTA |
9 | |
PJI_REP_XBS_DENORM |
19 | This table stores the denormalized information for project and program hierarchy |
PJI_RM_AGGR_RES6 |
14 | This intermediate table contains data to be loaded into PJI_RM_AGGR_RES1 when PJI RM summarization is run |
PJI_RM_DNGL_RES |
23 | Information about dangling records of resource summarization. |
PJI_RM_RES_F |
53 | This table stores summarized data for utilization and availabilty measures by resources for project intelligence |
PJI_RM_RES_WT_F |
23 | This table stores summarized data for utilization and availabilty measures by resource and worktype for project intelligence |
PJI_RM_REXT_FCSTITEM |
6 | This is an intermediate summarization table. |
PJI_RM_WORK_TYPE_INFO |
13 | Information about the work type. |
PJI_ROLLUP_LEVEL_STATUS |
15 | This table indicates if the resource rollup slices by the resource breakdown structure are created or not for a project and a plan |
PJI_SYSTEM_CONFIG_HIST |
13 | History of the configuration of your Oracle Projects Intelligence |
PJI_SYSTEM_DEBUG_MSG |
8 | Debug messages for Projects Intelligence |
PJI_SYSTEM_PARAMETERS |
2 | Information about the configuration of an Oracle Projects Intelligence installation |
PJI_SYSTEM_PRC_STATUS |
6 | Status of the steps that have been submitted |
PJI_SYSTEM_SETTINGS |
75 | Information about the configuration of an Oracle Projects Intelligence installation |
PJI_TIME_CAL_EXTR_INFO |
8 | This table stores last extraction information for all calendards that have been extracted to project performance-reporting model. |
PJI_TIME_CAL_PERIOD |
12 | This table stores period definition for fiscal calendar |
PJI_TIME_CAL_QTR |
12 | This table stores quarter definition for fiscal calendar |
PJI_TIME_CAL_RPT_STRUCT |
11 | This table stores fiscal time dimension information in a special format required for project performance reports |
PJI_TIME_CAL_YEAR |
11 | This table stores year definition for fiscal calendar |
PJI_TIME_ENT_PERIOD |
12 | This table stores period definition for enterprise calendar |
PJI_TIME_ENT_QTR |
11 | This table stores quarter definition for enterprise calendar |
PJI_TIME_ENT_YEAR |
12 | This table stores year definition for enterprise calendar |
PJI_TIME_RPT_STRUCT |
11 | This table stores enterprise time dimension information in a special format required for project performance reports |
PJI_TIME_WEEK |
11 | This table stores week definition for enterprise calendar |
PJI_XBS_DENORM |
20 | This table stores normalized work breakdown structure and program hierarchy information |
PJI_XBS_DENORM_DELTA |
18 | Used during PJP summarization, this table stores the difference between PA_XBS_DENORM and PJI_XBS_DENORM |
PJI_XBS_DENORM_T |
20 | This is an temporary table that is used to store XBS denorm data by the Refresh/Update Project Performance Data. This is a global temporary |