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.
Category: Oracle Fusion
Payment Process Request Query in Fusion
How to fetch the payment details in Fusion Finance i.e. Payment Process Profile, Payment Method and other selection criteria of the invoices.
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
Sales Order Query in Oracle Fusion
Retrieving the Sales Order Details in Oracle Fusion
Charts Of Accounts structure – Segments and Value Set
Query to find out the charts of account structure in Oracle Fusion Finance and corresponding value sets.