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. You can't join across them in OTBI, the owned conformed model joins them on shared 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