Oracle Fusion · Data dictionary
CMR_ALL_PERIOD_VALERR_TXNS_V
SharedUsed in 1 subject areas18 reporting columns
Channel Management / Rebates (CMR), denormalized view.
Primary key: not yet catalogued for CMR_ALL_PERIOD_VALERR_TXNS_V, reference Oracle Tables & Views guide.
Columns
| Column | Key | In reports | Description (inferred) |
|---|---|---|---|
| DESTINATION_TYPE_CODE | ● | Code identifying the destination type. | |
| DISTRIBUTION_TYPE | ● | Type of distribution. | |
| DOCUMENT_TYPE_CODE | ● | Code identifying the document type. | |
| END_DATE | ● | End date. | |
| ERROR_CODE | ● | Code identifying the error. | |
| PERIOD_NAME | ● | Name of the period. | |
| PERIOD_NUM | ● | Period number. | |
| PERIOD_SET_NAME | ● | Name of the period set. | |
| PERIOD_TYPE | ● | Type of period. | |
| PERIOD_YEAR | ● | Period year. | |
| SOURCE_TABLE | ● | Source table. | |
| START_DATE | ● | Start date. | |
| TRANSACTION_DATE | ● | Transaction date. | |
| TRANSACTION_LINE_NUMBER | ● | Transaction line number. | |
| TRANSACTION_NUMBER | ● | Transaction number. | |
| TRANSACTION_QTY | ● | Transaction quantity. | |
| TRANSACTION_TYPE | ● | Type of transaction. | |
| TRANSACTION_UOM_CODE | ● | Code identifying the transaction 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 CMR_ALL_PERIOD_VALERR_TXNS_V?
We ship parameterized SQL, BICC config, and dbt models you own.
Problems that run through this table