Constraints, indexes, Oracle Fusion, Table Structure

Item Catalog Category Table Details

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,, Fusion Payment System, Oracle Fusion, Oracle Fusion Finance

How To Fetch (Query) The Payment Details In Fusion

To illustrate the data base structure of Oracle Fusion Payment system i.e. how the different entities like Payment Process Request, Payment, Checks and Invoices are connected to each other and the basic Payment Query.

BI Report, Business Intelligence Report,, Oracle Fusion, Oracle Fusion Finance, sales Order, shipment

Shipment Details Query In Oracle Fusion

SQL to fetch the shipment details like Shipment, carrier, Bill of Lading, item, inventory, sub inventory , ship to party etc