Oracle Fusion · Data dictionary
EGP_FLATTENED_VALID_CATS_VL
SharedUsed in 1 subject areas48 reporting columns
Product Hub / Items (EGP), view layer, joins the base table with translations for the current language.
Primary key: not yet catalogued for EGP_FLATTENED_VALID_CATS_VL, reference Oracle Tables & Views guide.
Joins (inferred from key columns): CATEGORY_ID → FA_CATEGORIES_B
Columns
| Column | Key | In reports | Description (inferred) |
|---|---|---|---|
| CATEGORY_ID | ● | Identifier for the category. | |
| CATEGORY_SET_ID | ● | Identifier for the category set. | |
| CATEGORY_SHARED_FLAG | ● | Indicator (Y/N) for the category shared. | |
| PARENT_CATEGORY_CODE1 | ● | Parent category code1. | |
| PARENT_CATEGORY_CODE10 | ● | Parent category code10. | |
| PARENT_CATEGORY_CODE11 | ● | Parent category code11. | |
| PARENT_CATEGORY_CODE12 | ● | Parent category code12. | |
| PARENT_CATEGORY_CODE13 | ● | Parent category code13. | |
| PARENT_CATEGORY_CODE14 | ● | Parent category code14. | |
| PARENT_CATEGORY_CODE15 | ● | Parent category code15. | |
| PARENT_CATEGORY_CODE2 | ● | Parent category code2. | |
| PARENT_CATEGORY_CODE3 | ● | Parent category code3. | |
| PARENT_CATEGORY_CODE4 | ● | Parent category code4. | |
| PARENT_CATEGORY_CODE5 | ● | Parent category code5. | |
| PARENT_CATEGORY_CODE6 | ● | Parent category code6. | |
| PARENT_CATEGORY_CODE7 | ● | Parent category code7. | |
| PARENT_CATEGORY_CODE8 | ● | Parent category code8. | |
| PARENT_CATEGORY_CODE9 | ● | Parent category code9. | |
| PARENT_CATEGORY_DESCRIPTION1 | ● | Parent category description1. | |
| PARENT_CATEGORY_DESCRIPTION10 | ● | Parent category description10. | |
| PARENT_CATEGORY_DESCRIPTION11 | ● | Parent category description11. | |
| PARENT_CATEGORY_DESCRIPTION12 | ● | Parent category description12. | |
| PARENT_CATEGORY_DESCRIPTION13 | ● | Parent category description13. | |
| PARENT_CATEGORY_DESCRIPTION14 | ● | Parent category description14. | |
| PARENT_CATEGORY_DESCRIPTION15 | ● | Parent category description15. | |
| PARENT_CATEGORY_DESCRIPTION2 | ● | Parent category description2. | |
| PARENT_CATEGORY_DESCRIPTION3 | ● | Parent category description3. | |
| PARENT_CATEGORY_DESCRIPTION4 | ● | Parent category description4. | |
| PARENT_CATEGORY_DESCRIPTION5 | ● | Parent category description5. | |
| PARENT_CATEGORY_DESCRIPTION6 | ● | Parent category description6. | |
| PARENT_CATEGORY_DESCRIPTION7 | ● | Parent category description7. | |
| PARENT_CATEGORY_DESCRIPTION8 | ● | Parent category description8. | |
| PARENT_CATEGORY_DESCRIPTION9 | ● | Parent category description9. | |
| PARENT_CATEGORY_NAME1 | ● | Parent category name1. | |
| PARENT_CATEGORY_NAME10 | ● | Parent category name10. | |
| PARENT_CATEGORY_NAME11 | ● | Parent category name11. | |
| PARENT_CATEGORY_NAME12 | ● | Parent category name12. | |
| PARENT_CATEGORY_NAME13 | ● | Parent category name13. | |
| PARENT_CATEGORY_NAME14 | ● | Parent category name14. | |
| PARENT_CATEGORY_NAME15 | ● | Parent category name15. | |
| PARENT_CATEGORY_NAME2 | ● | Parent category name2. | |
| PARENT_CATEGORY_NAME3 | ● | Parent category name3. | |
| PARENT_CATEGORY_NAME4 | ● | Parent category name4. | |
| PARENT_CATEGORY_NAME5 | ● | Parent category name5. | |
| PARENT_CATEGORY_NAME6 | ● | Parent category name6. | |
| PARENT_CATEGORY_NAME7 | ● | Parent category name7. | |
| PARENT_CATEGORY_NAME8 | ● | Parent category name8. | |
| PARENT_CATEGORY_NAME9 | ● | Parent category name9. |
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. In OTBI they combine only through shared dimensions or set operators such as union, inside one application; the owned conformed model joins this table across modules and systems on conformed keys.
Need the extract + dbt staging for EGP_FLATTENED_VALID_CATS_VL?
We ship parameterized SQL, BICC config, and dbt models you own.
Problems that run through this table