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

VRM_FMV_DATA_SET_USAGES

SharedUsed in 1 subject areas20 reporting columns

Revenue Management (VRM).

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

Columns

ColumnKeyIn reportsDescription (inferred)
BASE_PRICEBase price.
COMMENTSComments.
CREATED_BYUser who created the row.
CREATION_DATEDate and time the row was created.
DATA_SET_TYPEType of data set.
DOCUMENT_LINE_IDIdentifier for the document line.
EXCLUDED_BYExcluded by.
EXCLUSION_REASON_CODECode identifying the exclusion reason.
EXCLUSION_STATUSStatus of the exclusion.
LAST_UPDATED_BYUser who last updated the row.
LAST_UPDATE_DATEDate and time the row was last updated (the incremental-extract key).
NET_DISCOUNT_AMOUNTNet discount amount.
NET_DISCOUNT_PERCENTNet discount percentage.
NET_LINE_AMOUNTNet line amount.
NET_QUANTITYNet quantity.
NET_UNIT_SALES_PCT_BASE_PRICENet unit sales percent base price.
NET_UNIT_SALES_PRICENet unit sales price.
REVISED_COSTRevised cost.
REVISED_GROSS_MARGIN_PERCENTRevised gross margin percentage.
REVISED_UOMRevised 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 VRM_FMV_DATA_SET_USAGES?
We ship parameterized SQL, BICC config, and dbt models you own.
Talk to us