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. You can't join across them in OTBI, the owned conformed model joins them on shared 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