Tag: Fusion

Oracle Fusion Finance

Supplier Details Query in Oracle Fusion

Mohit Saxena

Query to fetch the details of a supplier such as Supplier Name, number, DUNS number, tax payer id, contact address, supplier type

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