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
Want to give back to the society? (Do you have something which you think can be used by folks working on Oracle world wide?) Then Click here, share your email id and a brief description of the topic. And keep your photo and the content ready.
By the way, Here ( India) or Here ( Other Geographies) are few UNCONVENTIONAL tricks which I have learnt to improve the performance of BI reports. 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