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_COST●Allocated extended cost.
ALLOCATED_MATERIAL_COST●Allocated material cost.
ALLOCATED_MATERIAL_COST_SR●Allocated material cost sr.
ALLOCATED_OVERHEAD_COST●Allocated overhead cost.
ALLOCATED_OVERHEAD_COST_SR●Allocated overhead cost sr.
ALLOCATED_RESOURCE_COST●Allocated resource cost.
ALLOCATED_RESOURCE_COST_SR●Allocated resource cost sr.
ALLOCATED_UNIT_COST●Allocated unit cost.
ALLOCATED_UNIT_COST_SR●Allocated unit cost sr.
BASIS_TYPE●Type of basis.
BATCH_QUANTITY●Batch quantity.
BATCH_UOM_CODE●Code identifying the batch unit of measure.
COSTING_BATCH_OUTPUT_SIZE●Costing batch output size.
COST_ALLOCATION_PERCENTAGE●Cost allocation percentage.
COST_UOM_CODE●Code identifying the cost unit of measure.
CUMULATIVE_EXTENDED_COST●Cumulative extended cost.
CUMULATIVE_UNIT_COST●Cumulative unit cost.
CURRENCY_CODE●Code identifying the currency.
EXTENDED_COST●Extended cost.
MATERIAL_COST●Material cost.
OP_REV_YIELD_FACTOR●Op rev yield factor.
OP_YIELD_FACTOR●Op yield factor.
OUTPUT_TYPE●Type of output.
OVERHEAD_COST●Overhead cost.
QUANTITY●Quantity.
RESOURCE_COST●Resource cost.
SOURCE_TYPE●Type of source.
UNALLOCATED_UNIT_COST●Unallocated unit cost.
UNIT_COST●Unit cost.
UNIT_OF_MEASURE●Unit of measure.
WORK_METHOD_CODE●Code 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. In OTBI they combine only through shared dimensions or set operators such as union, inside one application; the owned conformed model joins this table across modules and systems on conformed 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