Analytics Catalog/Data dictionary/DOO_MANUAL_PRICE_ADJUSTMENTS
Explore the catalogReportsModulesEnterprise modelOTBI subject areasBICC PVOs
Oracle Fusion · Data dictionary

DOO_MANUAL_PRICE_ADJUSTMENTS

SharedUsed in 1 subject areas10 reporting columns

Order Management (DOO).

Primary key: not yet catalogued for DOO_MANUAL_PRICE_ADJUSTMENTS — reference Oracle Tables & Views guide.

Columns

ColumnKeyIn reportsDescription (inferred)
ADJUSTMENT_AMOUNTAdjustment amount.
ADJUSTMENT_TYPE_CODECode identifying the adjustment type.
CHARGE_ROLLUP_FLAGIndicator (Y/N) for the charge rollup.
EFFECTIVITY_TYPE_CODECode identifying the effectivity type.
NUMBER_OF_PERIODSNumber of periods.
PERIOD_FROMPeriod from.
PERIOD_UNTILPeriod until.
PRICE_PERIODICITY_CODECode identifying the price periodicity.
REASON_CODECode identifying the reason.
SEQUENCE_NUMBERSequence number.

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 DOO_MANUAL_PRICE_ADJUSTMENTS?
We ship parameterized SQL, BICC config, and dbt models you own.
Talk to us