EGP_CATEGORY_SETS_B
Product: EGPcontrolCatalog (category set) definitions — control level, the multiple-assignments flag, hierarchy option, and the default category new items inherit
Fusion calls these catalogs — CATALOG_CODE is the user-facing identifier and the catalog NAME lives only on the translation companion (EGP_CATEGORY_SETS_TL, not yet cataloged). CONTROL_LEVEL decides whether assignments flow to child organizations automatically.
What the badges mean
- master
- Data class: what the table holds — master data, transaction documents, control/configuration, interface/staging, or a documented view.
Extract access
The delivered surfaces that reach this table — the BICC extract data store (PVO) for bulk extraction and the OTBI subject areas for real-time queries. There is no SQL path to the SaaS database.
- FscmTopModelAM.ScmExtractAM.EgpBiccExtractAM.CatalogExtractPVOOTBI: Product Management - Item Catalog Category Hierarchy Real Time
Catalogs data store — keyed on CategorySetId (Fusion's catalog IS the category set). Translated catalog names ride CatalogTranslationExtractPVO.
Oracle data-store documentation →
Fields
8 fields · 1 key
| # | Field | Description | Type | Flags |
|---|---|---|---|---|
| 1 | CATEGORY_SET_ID | Catalog (category set) surrogate key | NUMBER | Key |
| 2 | CATALOG_CODE | The user-facing catalog code | VARCHAR2 | |
| 3 | CONTROL_LEVEL | Whether assignments flow automatically to child organizations | NUMBER | |
| 4 | DEFAULT_CATEGORY_ID | Category auto-assigned at item creation | NUMBER | |
| 5 | MULT_ITEM_CAT_ASSIGN_FLAG | Allows one item in multiple categories of this catalog — the double-count switch | VARCHAR2 | |
| 6 | HIERARCHY_ENABLED | Catalog supports a category hierarchy | VARCHAR2 | |
| 7 | START_DATE | Catalog activation date | DATE | |
| 8 | END_DATE | Catalog deactivation date | DATE |
Field provenance: hand-curated. 1 key field.
Boilerplate SQL
Starting point for reading the BICC-landed copy of EGP_CATEGORY_SETS_Bon Databricks — real DATE columns need no conversion, and the org anchor and the LAST_UPDATE_DATE watermark (the column incremental BICC extracts key on) are already in place. Set your Unity Catalog location, schema, and org values below; they’re substituted into the SQL and the copy button.
-- ============================================================
-- Table : EGP_CATEGORY_SETS_B — Catalog (category set) definitions — control level, the multiple-assignments flag, hierarchy option, and the default category new items inherit
-- Purpose: Column-selected read of EGP_CATEGORY_SETS_B — auto-generated from field metadata
-- Grain : One row per CATEGORY_SET_ID
-- Notes : Auto-generated skeleton for Oracle Fusion Cloud data landed in your lakehouse by a BICC extract — there is no SQL path to the SaaS database. Column names follow Oracle's table documentation — if your landed data still carries PVO attribute headers, map names first; see quirks #pvo-drift. Dates are real DATE/TIMESTAMP columns — no conversion needed. WHO audit columns omitted (see the quirks guide); the optional LAST_UPDATE_DATE watermark filter supports incremental extracts.
-- ============================================================
SELECT
t.CATEGORY_SET_ID AS "Catalog (category set) surrogate key",
t.CATALOG_CODE AS "The user-facing catalog code",
t.CONTROL_LEVEL AS "Whether assignments flow automatically to child organizations",
t.DEFAULT_CATEGORY_ID AS "Category auto-assigned at item creation",
t.MULT_ITEM_CAT_ASSIGN_FLAG AS "Allows one item in multiple categories of this catalog — the double-count switch",
t.HIERARCHY_ENABLED AS "Catalog supports a category hierarchy",
t.START_DATE AS "Catalog activation date",
t.END_DATE AS "Catalog deactivation date"
FROM <catalog>.<schema>.EGP_CATEGORY_SETS_B t
WHERE
1 = 1 -- no partition column on this table; the filters below are optional
-- AND t.CATEGORY_SET_ID = <CATEGORY_SET_ID>
-- AND t.LAST_UPDATE_DATE >= TIMESTAMP '<watermark>' -- the column incremental BICC extracts key on
ORDER BY t.CATEGORY_SET_ID;4 parameters not filled: <catalog>, <schema>, <CATEGORY_SET_ID>, <watermark>
Relationships
1-hop neighbors — click a table to navigate there. FND lookup decode and translation edges are highlighted; they’re the joins newcomers most often get wrong.
Join details
ON EGP_ITEM_CAT_ASSIGNMENTS.CATEGORY_SET_ID = EGP_CATEGORY_SETS_B.CATEGORY_SET_IDON EGP_CATEGORY_SETS_B.DEFAULT_CATEGORY_ID = EGP_CATEGORIES_B.CATEGORY_ID