Oracle Fusion · Data dictionary
XCC_TR_LINES
SharedUsed in 1 subject areas16 reporting columns
line table — one row per line item under the header.
Likely primary key: TR_HEADER_ID, LINE_NUM (inferred from Oracle naming conventions — verify against Tables & Views)
Columns
| Column | Key | In reports | Description (inferred) |
|---|---|---|---|
| BUDGET_DATE | ● | Budget date. | |
| CONVERSION_DATE | ● | Conversion date. | |
| CONVERSION_TYPE_CODE | ● | Code identifying the conversion type. | |
| ENTERED_AMOUNT | ● | Entered amount. | |
| ENTERED_CURRENCY | ● | Entered currency. | |
| LEDGER_AMOUNT | ● | Ledger amount. | |
| LINE_NUM | PK? | ● | Line number. |
| LIQUIDATION_AMOUNT | ● | Liquidation amount. | |
| LIQUIDATION_DATE | ● | Liquidation date. | |
| LIQUIDATION_QUANTITY | ● | Liquidation quantity. | |
| LIQUIDATION_TRANS_TYPE_CODE | ● | Code identifying the liquidation trans type. | |
| PRICE | ● | Price. | |
| QUANTITY | ● | Quantity. | |
| STATISTICAL_AMOUNT | ● | Statistical amount. | |
| TRANSACTION_SUBTYPE_CODE | ● | Code identifying the transaction subtype. | |
| TR_HEADER_ID | PK? | ○ | Identifier for the tr header. |
| UOM_CODE | ● | Code identifying the unit of measure. |
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 XCC_TR_LINES?
We ship parameterized SQL, BICC config, and dbt models you own.