ACE_PF_SCENARIO_B

SharedUsed in 9 subject areas58 reporting columns

base table — language-neutral data (paired with _TL labels and the _VL view).

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

Columns

Column	In reports	Description (inferred)
ACTUAL_COST	●	Actual cost.
ACTUAL_DEVELOPMENT_COST	●	Actual development cost.
ACTUAL_DEV_FIXED_COST	●	Actual dev fixed cost.
ACTUAL_DEV_LABOR_COST	●	Actual dev labor cost.
ACTUAL_DEV_MATERIAL_COST	●	Actual dev material cost.
ACTUAL_DEV_VARIABLE_COST	●	Actual dev variable cost.
ACTUAL_PRODUCTION_COST	●	Actual production cost.
ACTUAL_PROD_FIXED_COST	●	Actual prod fixed cost.
ACTUAL_PROD_LABOR_COST	●	Actual prod labor cost.
ACTUAL_PROD_MATERIAL_COST	●	Actual prod material cost.
ACTUAL_PROD_VARIABLE_COST	●	Actual prod variable cost.
ACTUAL_RESOURCES	●	Actual resources.
ACTUAL_REVENUE	●	Actual revenue.
ALIGNMENT	●	Alignment.
COMPETITIVE_ADVANTAGE	●	Competitive advantage.
COST_DEVIATION	●	Cost deviation.
COST_VALUE_INDEX	●	Cost value index.
CPI	●	Cpi.
CREATOR	●	Creator.
DATE_CREATED	●	Date created.
EXPECTED_COMMERCIAL_VALUE	●	Expected commercial value.
IMPACT	●	Impact.
INTERNAL_RATE_OF_RETURN	●	Internal rate of return.
IS_ENABLED	●	Is enabled.
MARGIN_DEVIATION	●	Margin deviation.
NET_PRESENT_VALUE	●	Net present value.
PAYBACK_PERIOD	●	Payback period.
PORTFOLIO_ID	●	Identifier for the portfolio.
PORTFOLIO_REVISION_ID	●	Identifier for the portfolio revision.
PORTFOLIO_RISK_NUMERIC	●	Portfolio risk numeric.
PORTFOLIO_RISK_SUBJECTIVE	●	Portfolio risk subjective.
PORTFOLIO_STRATEGIC_FIT	●	Portfolio strategic fit.
PORTFOLIO_STRATEGIC_IMP	●	Portfolio strategic imp.
PROJECTED_COST	●	Projected cost.
PROJECTED_MARGIN	●	Projected margin.
PROJECTED_RESOURCES	●	Projected resources.
PROJECTED_REVENUE	●	Projected revenue.
PROJ_DEV_COST	●	Proj dev cost.
PROJ_DEV_FIXED_COST	●	Proj dev fixed cost.
PROJ_DEV_LABOR_COST	●	Proj dev labor cost.
PROJ_DEV_MATERIAL_COST	●	Proj dev material cost.
PROJ_DEV_VARIABLE_COST	●	Proj dev variable cost.
PROJ_PROD_COST	●	Proj prod cost.
PROJ_PROD_FIXED_COST	●	Proj prod fixed cost.
PROJ_PROD_LABOR_COST	●	Proj prod labor cost.
PROJ_PROD_MATERIAL_COST	●	Proj prod material cost.
PROJ_PROD_VARIABLE_COST	●	Proj prod variable cost.
RESOURCE_VALUE_INDEX	●	Resource value index.
REVENUE_DEVIATION	●	Revenue deviation.
RND_KNOW_HOW	●	Rnd know how.
ROI	●	Roi.
RPI	●	Rpi.
SCENARIO_ID	●	Identifier for the scenario.
STATUS	●	Status.
SUPPLY_CHAIN_FIT	●	Supply chain fit.
YEAR_2_REVENUE	●	Year 2 revenue.
YEAR_3_REVENUE	●	Year 3 revenue.
YEAR_5_REVENUE	●	Year 5 revenue.

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 ACE_PF_SCENARIO_B?

We ship parameterized SQL, BICC config, and dbt models you own.

Talk to us