Oracle Fusion · Data dictionary
AR_RECEIVABLES_TRX_ALL
ReceivablesUsed in 5 subject areas1 reporting columns
Receivables (AR), transaction table (rows scoped across all operating units).
Primary key: RECEIVABLES_TRX_ID, ORG_ID (Oracle's AR_RECEIVABLES_TRX_PK)
Columns
| Column | Key | In reports | Description (inferred) |
|---|---|---|---|
| NAME | ● | Name. | |
| RECEIVABLES_TRX_ID | PK | ○ | Identifier for the receivables transaction. |
2 reports read from this table
Change a column here and these are the reports that move with it, the blast radius for any change to AR_RECEIVABLES_TRX_ALL.
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.
- Receivables - Adjustments Real Time
- Receivables - Credit Memo Applications Real Time
- Receivables - Miscellaneous Receipts Real Time
- Receivables - Standard Receipts Application Details Real Time
- Subledger Accounting - Journals Real Time
Need the extract + dbt staging for AR_RECEIVABLES_TRX_ALL?
We ship parameterized SQL, BICC config, and dbt models you own.
Problems that run through this table