Author: Mohit Saxena

Hi, This is your friend Mohit Saxena, An Oracle Certified Associate. Having 13+ years of experience in various Oracle projects, across geographies and modules and products. This blog is to share my experience with hope that it can help you. if you have any question, suggestion or feedback, pls do share.
Constraints, indexes, Oracle Fusion, Table Structure

Item Catalog Category Table Details

Mohit Saxena

Table structure of item catalog categories table like egp_category_sets_b, egp_categories_tl, egp_item_categories, egp_categories_b etc

BI Report, Business Intelligence Report,, Oracle Fusion, Oracle Fusion Finance

Item Catalog – Category Assignment in Fusion

Mohit Saxena

Tables and queries needed to fetch item catalog and category & relationship between Catalog and categories.

BI Report, Business Intelligence Report,, Enterprise structure, Oracle Fusion

Subinventory Query in Oracle Fusion

Mohit Saxena

Query to fetch the subinventory details like inventory, picking Order, material status, depreciable, locator control, locator structure