Tag: Fusion Training

BI Report, Business Intelligence Report,, Constraints, indexes, Table Structure

EGP_SYSTEM_ITEMS_B : Item Table in Fusion

Mohit Saxena

Oracle Fusion item master table: Structure, indexes and constraints

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

How To Fetch (Query) The Payment Details In Fusion

Mohit Saxena

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

Mohit Saxena

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