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

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.
Joins (inferred from key columns): PORTFOLIO_ID → ACE_PORTFOLIO_B · PORTFOLIO_REVISION_ID → ACE_PORTFOLIO_REVISION

Columns

ColumnKeyIn reportsDescription (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. 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 ACE_PF_SCENARIO_B?
We ship parameterized SQL, BICC config, and dbt models you own.
Talk to us
Problems that run through this table
What the extract does not carry · The export ceiling · The extraction pattern