ACE_SELECTED_PRODUCTS

SharedUsed in 5 subject areas57 reporting columns

Source object in the Oracle Fusion data model.

Primary key: not yet catalogued for ACE_SELECTED_PRODUCTS — 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.
BUSINESS_UNIT_STRENGTH	●	Business unit strength.
COMPETITIVE_ADVANTAGE	●	Competitive advantage.
COST_VALUE_INDEX	●	Cost value index.
CPI	●	Cpi.
EXPECTED_COMMERCIAL_VALUE	●	Expected commercial value.
IMPACT	●	Impact.
INCLUDED	●	Included.
INTERNAL_RATE_OF_RETURN	●	Internal rate of return.
MARKET_ATTRACTIVENESS	●	Market attractiveness.
MARKET_GROWTH_PERCENT	●	Market growth percentage.
MARKET_SHARE_PERCENT	●	Market share percentage.
NET_PRESENT_VALUE	●	Net present value.
PAYBACK_PERIOD	●	Payback period.
PRIORITY	●	Priority.
PROB_OF_COMMERCIAL_SUCCESS	●	Prob of commercial success.
PROB_OF_TECHNICAL_SUCCESS	●	Prob of technical success.
PRODUCT_CATEGORIZATION	●	Product categorization.
PRODUCT_STRATEGIC_FIT	●	Product strategic fit.
PRODUCT_STRATEGIC_IMP	●	Product strategic imp.
PROJECTED_COST	●	Projected cost.
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.
RANK	●	Rank.
RESOURCE_VALUE_INDEX	●	Resource value index.
RISK_NUMBERIC	●	Risk numberic.
RISK_SUBJECTIVE	●	Risk subjective.
RND_KNOW_HOW	●	Rnd know how.
ROI	●	Roi.
SCORE	●	Score.
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_SELECTED_PRODUCTS?

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

Talk to us