Oracle Fusion · Data dictionary
XLA_CMR_RCV_EVNT_DSTRBNS_V
Subledger AccountingUsed in 1 subject areas9 reporting columns
Subledger Accounting (XLA), denormalized view.
Primary key: not yet catalogued for XLA_CMR_RCV_EVNT_DSTRBNS_V, reference Oracle Tables & Views guide.
Joins (inferred from key columns): BALANCE_TYPE_CODE → PAY_BALANCE_TYPES_VL
Columns
| Column | Key | In reports | Description (inferred) |
|---|---|---|---|
| BALANCE_TYPE_CODE | ● | Code identifying the balance type. | |
| CMR_SUB_LEDGER_ID | ● | Identifier for the cmr sub ledger. | |
| GL_BATCH_DESC | ● | Description of the general ledger batch. | |
| GL_BATCH_NAME | ● | Name of the general ledger batch. | |
| GL_BATCH_STATUS | ● | Status of the general ledger batch. | |
| GL_TRANSFER_DATE | ● | General ledger transfer date. | |
| GL_TRANSFER_STATUS_CODE | ● | Code identifying the general ledger transfer status. | |
| SLA_DR_CR_SIGN | ● | Sla dr cr sign. | |
| SLA_LEDGER_AMOUNT | ● | Sla ledger amount. |
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.
Need the extract + dbt staging for XLA_CMR_RCV_EVNT_DSTRBNS_V?
We ship parameterized SQL, BICC config, and dbt models you own.
Problems that run through this table