Oracle Fusion · Data dictionary
EGP_CATEGORY_SETS_B
SharedUsed in 39 subject areas12 reporting columns
Product Hub / Items (EGP) — base table — language-neutral data (paired with _TL labels and the _VL view).
Likely primary key: SOURCE_CATEGORY_SET_ID (inferred from Oracle naming conventions — verify against Tables & Views)
Columns
| Column | Key | In reports | Description (inferred) |
|---|---|---|---|
| CATALOG_CODE | ● | Code identifying the catalog. | |
| CATALOG_CONTENT_CODE | ● | Code identifying the catalog content. | |
| CONTROL_LEVEL | ● | Control level. | |
| DEFAULT_CATEGORY_ID | ● | Identifier for the default category. | |
| END_DATE | ● | End date. | |
| HIERARCHY_ENABLED | ● | Hierarchy enabled. | |
| MULT_ITEM_CAT_ASSIGN_FLAG | ● | Indicator (Y/N) for the mult item cat assign. | |
| MULT_ITEM_CAT_UPDATEABLE_FLAG | ● | Indicator (Y/N) for the mult item cat updateable. | |
| SHARING_CONTENT_CODE | ● | Code identifying the sharing content. | |
| SOURCE_CATEGORY_SET_ID | PK? | ● | Identifier for the source category set. |
| START_DATE | ● | Start date. | |
| VALIDATE_FLAG | ● | Indicator (Y/N) for the validate. |
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.
- Distributed Order Orchestration - Fulfillment Lines Real Time
- Distributed Order Orchestration - Order Holds Real Time
- Distributed Order Orchestration - Order Lines Real Time
- Distributed Order Orchestration - Price Adjustments Real Time
- Inventory - Inventory Balance Real Time
- Inventory - Inventory Supply Real Time
- Inventory - Inventory Transactions Real Time
- Procurement - Procure To Pay Real Time
- Procurement - Purchasing Agreements Real Time
- Procurement - Purchasing Real Time
- Procurement - Spend Real Time
- Product Management - Change Order Approvals Real Time
- Product Management - Change Order Line Real Time
- Product Management - Change Order Real Time
- Product Management - Components Real Time
- Product Management - Cross Reference Item Real Time
- Product Management - Item Catalog Category Hierarchy Real Time
- Product Management - Item Revisions Real Time
- Product Management - Item Supplier Associations Real Time
- Product Management - New Item Request Approvals Real Time
Need the extract + dbt staging for EGP_CATEGORY_SETS_B?
We ship parameterized SQL, BICC config, and dbt models you own.