Oracle Fusion · Data dictionary
PJB_INVOICE_LINES
ProjectsUsed in 1 subject areas10 reporting columns
Projects Billing (PJB) — line table — one row per line item under the header.
Likely primary key: INVOICE_HEADER_ID, INVOICE_LINE_NUM (inferred from Oracle naming conventions — verify against Tables & Views)
Columns
| Column | Key | In reports | Description (inferred) |
|---|---|---|---|
| ASSESSABLE_VALUE | ● | Assessable value. | |
| CREDIT_PROCESSED_FLAG | ● | Indicator (Y/N) for the credit processed. | |
| EXCEPTION_FLAG | ● | Indicator (Y/N) for the exception. | |
| INVOICE_CURR_CREDIT_PCT | ● | Invoice currency credit percent. | |
| INVOICE_HEADER_ID | PK? | ○ | Identifier for the invoice header. |
| INVOICE_LINE_DESC | ● | Description of the invoice line. | |
| INVOICE_LINE_NUM | PK? | ● | Invoice line number. |
| INVOICE_LINE_TYPE | ● | Type of invoice line. | |
| PRODUCT_TYPE | ● | Type of product. | |
| TRANSLATED_TEXT | ● | Translated text. | |
| WRITE_OFF_FLAG | ● | Indicator (Y/N) for the write off. |
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.
Need the extract + dbt staging for PJB_INVOICE_LINES?
We ship parameterized SQL, BICC config, and dbt models you own.