Oracle Fusion · Data dictionary
PJC_EXP_GROUPS_ALL
ProjectsUsed in 4 subject areas2 reporting columns
Projects Costing (PJC), transaction table (rows scoped across all operating units).
Primary key: not yet catalogued for PJC_EXP_GROUPS_ALL, reference Oracle Tables & Views guide.
Columns
| Column | Key | In reports | Description (inferred) |
|---|---|---|---|
| EXPENDITURE_GROUP | ● | Expenditure group. | |
| USER_BATCH_NAME | ● | Name of the user batch. |
Used by reports
No cataloged report reads from this table yet, it's part of the broader Fusion dictionary.
- ,
Where this surfaces in OTBI
The OTBI subject areas that expose this table. You can't join across them in OTBI, the owned conformed model joins them on shared keys.
- Project Costing - Actual Costs Real Time
- Project Costing - Expenditure Item Performance - Real Time
- Project Costing - Unprocessed Transactions Real Time
- Subledger Accounting - Journals Real Time
Need the extract + dbt staging for PJC_EXP_GROUPS_ALL?
We ship parameterized SQL, BICC config, and dbt models you own.
Problems that run through this table