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

CST_ROLLUP_REPORTS

CostingUsed in 1 subject areas31 reporting columns

Cost Management (CST).

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

Columns

ColumnKeyIn reportsDescription (inferred)
ALLOCATED_EXTENDED_COSTAllocated extended cost.
ALLOCATED_MATERIAL_COSTAllocated material cost.
ALLOCATED_MATERIAL_COST_SRAllocated material cost sr.
ALLOCATED_OVERHEAD_COSTAllocated overhead cost.
ALLOCATED_OVERHEAD_COST_SRAllocated overhead cost sr.
ALLOCATED_RESOURCE_COSTAllocated resource cost.
ALLOCATED_RESOURCE_COST_SRAllocated resource cost sr.
ALLOCATED_UNIT_COSTAllocated unit cost.
ALLOCATED_UNIT_COST_SRAllocated unit cost sr.
BASIS_TYPEType of basis.
BATCH_QUANTITYBatch quantity.
BATCH_UOM_CODECode identifying the batch unit of measure.
COSTING_BATCH_OUTPUT_SIZECosting batch output size.
COST_ALLOCATION_PERCENTAGECost allocation percentage.
COST_UOM_CODECode identifying the cost unit of measure.
CUMULATIVE_EXTENDED_COSTCumulative extended cost.
CUMULATIVE_UNIT_COSTCumulative unit cost.
CURRENCY_CODECode identifying the currency.
EXTENDED_COSTExtended cost.
MATERIAL_COSTMaterial cost.
OP_REV_YIELD_FACTOROp rev yield factor.
OP_YIELD_FACTOROp yield factor.
OUTPUT_TYPEType of output.
OVERHEAD_COSTOverhead cost.
QUANTITYQuantity.
RESOURCE_COSTResource cost.
SOURCE_TYPEType of source.
UNALLOCATED_UNIT_COSTUnallocated unit cost.
UNIT_COSTUnit cost.
UNIT_OF_MEASUREUnit of measure.
WORK_METHOD_CODECode identifying the work method.

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