Analytics Catalog/Data dictionary/ACD_BUSINESS_DETAILS_VL
Explore the catalogReportsModulesEnterprise modelOTBI subject areasBICC PVOs
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

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_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.

Need the extract + dbt staging for ACD_BUSINESS_DETAILS_VL?
We ship parameterized SQL, BICC config, and dbt models you own.
Talk to us