Oracle Fusion · Data dictionary
CMR_PERIOD_CLOSE_ACTIONS_V
SharedUsed in 1 subject areas22 reporting columns
Channel Management / Rebates (CMR), denormalized view.
Primary key: not yet catalogued for CMR_PERIOD_CLOSE_ACTIONS_V, reference Oracle Tables & Views guide.
Columns
| Column | Key | In reports | Description (inferred) |
|---|---|---|---|
| END_DATE | ● | End date. | |
| INTRANSIT_PO_ACC_JOB_FLAG | ● | Indicator (Y/N) for the intransit purchase order acc job. | |
| INTRANSIT_PO_RPT_NOT_ACC_COUNT | ● | Intransit purchase order rpt not acc count. | |
| PENDING_ACCR_CLR_COUNT | ● | Pending accr clr count. | |
| PENDING_DIST_COUNT | ● | Pending distribution count. | |
| PENDING_INT_REVERSALS_COUNT | ● | Pending int reversals count. | |
| PENDING_INVOICE_INTF_COUNT | ● | Pending invoice intf count. | |
| PENDING_INVOICE_VAR_COUNT | ● | Pending invoice var count. | |
| PENDING_RECEIPT_COUNT | ● | Pending receipt count. | |
| PENDING_RECEIPT_INTF_COUNT | ● | Pending receipt intf count. | |
| PENDING_RPA_COUNT | ● | Pending rpa count. | |
| PENDING_TRA_COUNT | ● | Pending tra count. | |
| PENDING_TRA_INTF_COUNT | ● | Pending tra intf count. | |
| 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. | |
| START_DATE | ● | Start date. | |
| UNIMPORTED_INVOICE_COUNT | ● | Unimported invoice count. | |
| UNIMPORTED_RECEIPT_COUNT | ● | Unimported receipt count. | |
| UNINTERFACED_INT_SHPTS_COUNT | ● | Uninterfaced int shpts count. |
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_PERIOD_CLOSE_ACTIONS_V?
We ship parameterized SQL, BICC config, and dbt models you own.
Problems that run through this table