What is the primary key of CMR_PO_ACCRUAL_AMTS_RPT?

not marked in the source dictionary

Where is CMR_PO_ACCRUAL_AMTS_RPT used in reporting?

It appears in 1 OTBI subject areas.

Oracle Fusion · Data dictionary

SharedUsed in 1 subject areas26 reporting columns

Channel Management / Rebates (CMR).

Primary key: not yet catalogued for CMR_PO_ACCRUAL_AMTS_RPT, reference Oracle Tables & Views guide.

Column	In reports	Description (inferred)
ACCRUAL_AMT	●	Accrual amount.
ACCRUAL_QTY	●	Accrual quantity.
CREATED_BY	●	User who created the row.
CREATION_DATE	●	Date and time the row was created.
CURRENCY_CODE	●	Code identifying the currency.
CURRENCY_CONVERSION_DATE	●	Currency conversion date.
CURRENCY_CONVERSION_RATE	●	Currency conversion rate.
CURRENCY_CONVERSION_TYPE	●	Type of currency conversion.
FUNC_CURRENCY_CODE	●	Currency code for the func.
INVOICED_AMT	●	Invoiced amount.
INVOICED_QTY	●	Invoiced quantity.
INVOICE_AMT_FUNC_CURR	●	Invoice amount func currency.
INVOICE_VARIANCE_AMT	●	Invoice variance amount.
ITEM_DESCRIPTION	●	Description of the item.
LAST_UPDATED_BY	●	User who last updated the row.
LAST_UPDATE_DATE	●	Date and time the row was last updated (the incremental-extract key).
LINE_TYPE	●	Type of line.
PERIOD_END_DATE	●	Period end date.
PERIOD_NAME	●	Name of the period.
PERIOD_START_DATE	●	Period start date.
PO_AMOUNT	●	Purchase order amount.
PO_PRICE	●	Purchase order price.
PO_QUANTITY	●	Purchase order quantity.
RECEIVED_AMT	●	Received amount.
RECEIVED_QTY	●	Received quantity.
UOM_CODE	●	Code identifying the unit of measure.

No cataloged report reads from this table yet, it's part of the broader Fusion dictionary.

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_PO_ACCRUAL_AMTS_RPT?

We ship parameterized SQL, BICC config, and dbt models you own.

Problems that run through this table