Oracle Fusion · Data dictionary
ACD_BUSINESS_DETAILS_VL
SharedUsed in 5 subject areas66 reporting columns
view layer, joins the base table with translations for the current language.
Primary key: not yet catalogued for ACD_BUSINESS_DETAILS_VL, 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_LAUNCH | ● | Actual launch. | |
| ACTUAL_MARGIN | ● | Actual margin. | |
| 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. | |
| ALLOCATED_BUDGET | ● | Allocated budget. | |
| AVERAGE_SELLING_PRICE | ● | Average selling price. | |
| BREAK_EVEN_TIME | ● | Break even time. | |
| BUSINESS_OBJECTIVES | ● | Business objectives. | |
| BUSINESS_UNIT_STRENGTH | ● | Business unit strength. | |
| COMPETITIVE_ADVANTAGE | ● | Competitive advantage. | |
| COST_VALUE_INDEX | ● | Cost value index. | |
| CPI | ● | Cpi. | |
| DISCOUNT_RATE | ● | Discount rate. | |
| EXPECTED_COMMERCIAL_VALUE | ● | Expected commercial value. | |
| FUNDING_AMOUNT | ● | Funding amount. | |
| FUNDING_REQUEST_FOR | ● | Funding request for. | |
| IMPACT | ● | Impact. | |
| 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. | |
| 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. | |
| PROJECTED_MARGIN | ● | Projected margin. | |
| PROJECTED_RESOURCES | ● | Projected resources. | |
| 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. | |
| PROPOSAL_PROJECTED_COST | ● | Proposal projected cost. | |
| PROPOSAL_PROJECTED_REVENUE | ● | Proposal projected revenue. | |
| PROPOSAL_VERSION_NOTES | ● | Proposal version notes. | |
| RESOURCE_VALUE_INDEX | ● | Resource value index. | |
| RETURN_ON_INVESTMENT | ● | Return on investment. | |
| RISK_NUMBERIC | ● | Risk numberic. | |
| RISK_SUBJECTIVE | ● | Risk subjective. | |
| RND_KNOW_HOW | ● | Rnd know how. | |
| RPI | ● | Rpi. | |
| SUMMARY | ● | Summary. | |
| SUPPLY_CHAIN_FIT | ● | Supply chain fit. | |
| TARGET_COST | ● | Target cost. | |
| 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.
- Enterprise Quality Actions Real Time
- Enterprise Quality Issues Real Time
- Innovation Management - Product Proposals Cash Flow Real Time
- Innovation Management - Product Proposals Real Time
- Product Management - Change Order Real Time
Need the extract + dbt staging for ACD_BUSINESS_DETAILS_VL?
We ship parameterized SQL, BICC config, and dbt models you own.
Problems that run through this table