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.
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