Oracle Fusion · Data dictionary
PJC_PRJ_ASSET_LN_DETS
ProjectsUsed in 6 subject areas2 reporting columns
Projects Costing (PJC).
Primary key: PROJ_ASSET_LINE_DTL_UNIQ_ID (Oracle's PJC_PRJ_ASSET_LN_DETS_PK)
Joins (inferred from key columns): EXPENDITURE_ITEM_ID → PJC_EXP_ITEMS_ALL
Columns
| Column | Key | In reports | Description (inferred) |
|---|---|---|---|
| EXPENDITURE_ITEM_ID | ● | Identifier for the expenditure item. | |
| LINE_NUM | ● | Line number. | |
| PROJECT_ASSET_LINE_DETAIL_ID | ○ | Identifier for the project asset line detail. |
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. In OTBI they combine only through shared dimensions or set operators such as union, inside one application; the owned conformed model joins this table across modules and systems on conformed keys.
- Project Billing - Invoices Real Time
- Project Billing - Revenue Real Time
- Project Costing - Actual Costs Real Time
- Project Costing - Assets Real Time
- Project Costing - Expenditure Item Performance - Real Time
- Subledger Accounting - Journals Real Time
Need the extract + dbt staging for PJC_PRJ_ASSET_LN_DETS?
We ship parameterized SQL, BICC config, and dbt models you own.
Problems that run through this table