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
| Column | Key | In reports | Description (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. 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.