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
Problems that run through this table
Inventory as of any date · What the extract does not carry · The export ceiling