Oracle Fusion · Data dictionary
ACD_CONCEPT_STRUCTURE
SharedUsed in 4 subject areas18 reporting columns
Source object in the Oracle Fusion data model.
Primary key: not yet catalogued for ACD_CONCEPT_STRUCTURE — reference Oracle Tables & Views guide.
Columns
| Column | Key | In reports | Description (inferred) |
|---|---|---|---|
| ACTUAL_COST | ● | Actual cost. | |
| ACTUAL_POWER_CONSUMPTION | ● | Actual power consumption. | |
| ACTUAL_WEIGHT | ● | Actual weight. | |
| FIXED_COST | ● | Fixed cost. | |
| FROM_STR_ID | ● | Identifier for the from str. | |
| LEAD_TIME | ● | Lead time. | |
| MATERIAL_COST | ● | Material cost. | |
| NON_MATERIAL_COST | ● | Non material cost. | |
| NUMBER_MANUFACTURERS | ● | Number manufacturers. | |
| QUANTITY | ● | Quantity. | |
| RISK | ● | Risk. | |
| TARGET_COST | ● | Target cost. | |
| TARGET_POWER_CONSUMPTION | ● | Target power consumption. | |
| TARGET_WEIGHT | ● | Target weight. | |
| TOP_CONCEPT_ID | ● | Identifier for the top concept. | |
| TO_ID | ● | Identifier for the to. | |
| VENDOR | ● | Vendor. | |
| VOLUME | ● | Volume. |
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.
- Innovation Management - Concepts Real Time
- Innovation Management - Ideas Real Time
- Innovation Management - Product Proposals Real Time
- Innovation Management - Requirements Real Time
Need the extract + dbt staging for ACD_CONCEPT_STRUCTURE?
We ship parameterized SQL, BICC config, and dbt models you own.