PJI — Project Intelligence(Obsolete)

105 documented tables · 70 views — Oracle EBS ETRM 12.2.2

Most-referenced tables

Table	Description	Data Vault class*
PJI_CLASS_CATEGORIES	Implementation-defined categories for classifying project.	hub-leaning
PJI_FM_EXTR_PLN_LOG	Information about plan versions that have been extracted to project performance-reporting model.	link
PJI_AV_ORG_F	This table stores resource availability data by expenditure organization.	link
PJI_FP_TXN_ACCUM_HEADER	This table stores the resource attribute combinations which are used for resource breakdown structure mapping	link
PJI_PJP_RBS_HEADER	This table tracks associations between project, plan and Resource Breakdown Structures	link
PJI_RM_RES_WT_F	This table stores summarized data for utilization and availabilty measures by resource and worktype for projec	link
PJI_RM_RES_F	This table stores summarized data for utilization and availabilty measures by resources for project intelligen	link
PJI_FP_XBS_ACCUM_F	This table stores summarized cost, revenue, commitments measures for project performance by work breakdown, re	link
PJI_ROLLUP_LEVEL_STATUS	This table indicates if the resource rollup slices by the resource breakdown structure are created or not for	link
PJI_RBS_DENORM	This table stores normalized resource breakdown structure information	link
PJI_RESOURCES_DENORM	PJI_RESOURCES_DENORM is a denormalized table containing attributes for resources	link
PJI_FM_EXTR_PLAN_LINES	This table stores the changes to financial plan data	link
PJI_SYSTEM_SETTINGS	Information about the configuration of an Oracle Projects Intelligence installation	standalone
PJI_RM_WORK_TYPE_INFO	Information about the work type.	satellite-leaning
PJI_MT_BUCKETS	Information for bucket values for different measures.	standalone

*Heuristic classification mined from FK structure — a modeling suggestion, not Oracle's.

Key public APIs

Package	Class	Procedures	Used by
PJI_PERF_RPTG_PUB	PUB	2	0 packages

✨ Ask AI about PJI objects