Oracle Fusion · Data dictionary
FUN_TRX_HEADERS
IntercompanyUsed in 1 subject areas11 reporting columns
Intercompany / Federation (FUN), header table, one row per transaction or event (with detail in the paired _LINES table).
Primary key: TRX_ID
Columns
| Column | Key | In reports | Description (inferred) |
|---|---|---|---|
| APPROVAL_DATE | ● | Approval date. | |
| AR_INVOICE_NUMBER | ● | Receivables invoice number. | |
| DESCRIPTION | ● | Description. | |
| ERROR_REASON | ● | Error reason. | |
| INIT_AMOUNT_CR | ● | Init amount cr. | |
| INIT_AMOUNT_DR | ● | Init amount dr. | |
| INVOICE_FLAG | ● | Indicator (Y/N) for the invoice. | |
| RECI_AMOUNT_CR | ● | Reci amount cr. | |
| RECI_AMOUNT_DR | ● | Reci amount dr. | |
| REJECT_REASON | ● | Reject reason. | |
| TRX_ID | PK | ○ | Identifier for the transaction. |
| TRX_NUMBER | ● | Transaction number. |
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 FUN_TRX_HEADERS?
We ship parameterized SQL, BICC config, and dbt models you own.
Problems that run through this table