Oracle Fusion · Data dictionary
EGP_SUBSTITUTE_COMPONENTS
SharedUsed in 3 subject areas4 reporting columns
Product Hub / Items (EGP).
Likely primary key: SUBSTITUTE_COMPONENT_ID (inferred from Oracle naming conventions — verify against Tables & Views)
Columns
| Column | Key | In reports | Description (inferred) |
|---|---|---|---|
| ENFORCE_INT_REQUIREMENTS | ● | Enforce int requirements. | |
| PLANNING_PRIORITY | ● | Planning priority. | |
| SUBSTITUTE_COMPONENT_ID | PK? | ● | Identifier for the substitute component. |
| SUBSTITUTE_ITEM_QUANTITY | ● | Substitute item quantity. |
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.
- Manufacturing - Work Definitions Real Time
- Product Management - Structures and Components Real Time
- Product Management - Where Used Real Time
Need the extract + dbt staging for EGP_SUBSTITUTE_COMPONENTS?
We ship parameterized SQL, BICC config, and dbt models you own.