Oracle Fusion · Data dictionary
EGP_CATEGORIES_B
SharedUsed in 62 subject areas14 reporting columns
Product Hub / Items (EGP) — base table — language-neutral data (paired with _TL labels and the _VL view).
Primary key: not yet catalogued for EGP_CATEGORIES_B — reference Oracle Tables & Views guide.
Columns
| Column | Key | In reports | Description (inferred) |
|---|---|---|---|
| CATEGORY_CODE | ● | Code identifying the category. | |
| CATEGORY_CONTENT_CODE | ● | Code identifying the category content. | |
| END_DATE_ACTIVE | ● | End date active. | |
| SEGMENT1 | ● | Segment1. | |
| SEGMENT10 | ● | Segment10. | |
| SEGMENT2 | ● | Segment2. | |
| SEGMENT3 | ● | Segment3. | |
| SEGMENT4 | ● | Segment4. | |
| SEGMENT5 | ● | Segment5. | |
| SEGMENT6 | ● | Segment6. | |
| SEGMENT7 | ● | Segment7. | |
| SEGMENT8 | ● | Segment8. | |
| SEGMENT9 | ● | Segment9. | |
| START_DATE_ACTIVE | ● | Start date active. |
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.
- Costing - Cost Accounting Period Close Real Time
- Costing - Cost Rollup Details Real Time
- Costing - Overhead Rates Real Time
- Costing - Receipt Accounting Period Close Real Time
- Costing - Supply Chain Cost Rollup Real Time
- Costing - Transfer Order Receipt Landed Cost Charges Real Time
- Costing - Where Used Details Real Time
- 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
- Enterprise Contracts - Contracts Real Time
- Enterprise Quality Actions Real Time
- Enterprise Quality Issues Real Time
- Interfaced Fiscal Document Real Time
- Inventory - Inventory Balance Real Time
- Inventory - Inventory Supply Real Time
- Inventory - Inventory Transactions Real Time
- Maintenance Management - Purchased Item Usage Real Time
- Manufacturing - Actual Production Real Time
Need the extract + dbt staging for EGP_CATEGORIES_B?
We ship parameterized SQL, BICC config, and dbt models you own.