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.