Analytics Catalog/Oracle Fusion ERP/Projects
Explore the catalogReportsModulesEnterprise modelOTBI subject areasBICC PVOs
Oracle Fusion ERP · PROJ

Projects reports

Every Projects report — logic, source tables, parameterized SQL, the data dictionary, a star-schema data model, and extraction patterns. 8 reports.

Projects data model

The module's conformed star — the fact every Projects report rolls up to, surrounded by the dimensions shared across the module. See the full Projects data model → — all star schemas, the model dictionary, use cases, and every bicc View Object this module exposes.

PJC_EXP_ITEMS_ALLconformedGL_CODE_COMBINATIONSconformedPJF_PROJECTS_ALL_VLconformedPJF_PROJ_ELEMENTS_VLconformedPJF_PROJECTS_ALL_VLfact · Projects grainAmount · Count
●— fact → dimension join

Reports

PROJ
Project Listing Details Report
The master list of projects with their key attributes — number, name, type, organization, manager, status, dat…
PROJ
Projects Asset Management Report
Projects that build capital assets — the capital projects and their asset lines, showing construction-in-progr…
PROJ
Projects Budgets vs Actuals Report
Project budget against actual cost and commitments by task, with variance and percent spent, so project manage…
PROJ
Projects CIP TIP Asset Detail Report
Construction-in-progress detail at the accounting level — every cost line sitting in CIP by project and asset,…
PROJ
Projects Exceptions Report
Projects whose setup or plan has a problem — missing budget, no plan version, expired tasks with open cost, or…
PROJ
Projects Global vs Local CER Report
Capital expenditure requests (CER) compared at global and local levels — approved, committed, and spent agains…
PROJ
Projects Transactions Dashboard Report
Project cost transactions from across the subledgers — supplier invoices, expenses, and labor — tied to projec…
PROJ
Quarterly CIP FA by Project Report
The quarterly bridge from project CIP to Fixed Assets — what each project capitalized into Assets in the quart…