Oracle Fusion · Data dictionary
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 | Key | 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. 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.
- Innovation Management - Portfolio Cost Real Time
- Innovation Management - Portfolio Resource Real Time
- Innovation Management - Portfolio Revenue Real Time
- Innovation Management - Product Portfolio Real Time
- Innovation Management - Scenario Lifecycle Real Time
Need the extract + dbt staging for ACE_SELECTED_PRODUCTS?
We ship parameterized SQL, BICC config, and dbt models you own.
Problems that run through this table