This article is to give a brief description of tables used by Oracle Fusion Finance to store the details of Catalog, Category and how they are connected in the system.
Catalog Category Tables
egp_category_sets_tl: Translate table for catalogs. Download
egp_categories_b: Base table of category. Download
egp_category_set_valid_cats: Table to hold relationship between catalogs and categories. Download
egp_categories_tl: Translate table for categories. Download
egp_category_sets_b: Base table for catalogs. Download
egp_item_categories: Table to hold the relationship between item and the categories. Download
By the way, Here ( India) or Here ( Other Geographies) are few UNCONVENTIONAL tricks which I have learnt to improve the performance of BI reports or SQL queries. Try them only when nothing else works.. kind of SOS...
Related Posts:
Item Catalogs – Categories Assignment in Fusion
Item Table in Oracle Fusion – Inventory – EGP_SYSTEM_ITEMS_B
Item Detail Query in Oracle Fusion Finance
Feedback:
Hope the article helped you. If it did, please rate the post. In case it didn’t, do leave a comment to let us know what did we miss.
Reference:
support.oracle.com