Tag: Oracle Training

Constraints, indexes, Oracle Fusion, Oracle Fusion Finance, sales Order, Table Structure

Oracle Fusion Sales Order Table – DOO_HEADERS_ALL

Mohit Saxena

To provide the table structure & indexes of DOO_HEADERS_ALL table in Oracle Fusion which holds the Sales Order Header Data in Oracle Fusion.

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