Query to fetch the details of a supplier such as Supplier Name, number, DUNS number, tax payer id, contact address, supplier type
Tag: Oracle
Oracle Fusion Sales Order Table – DOO_HEADERS_ALL
To provide the table structure & indexes of DOO_HEADERS_ALL table in Oracle Fusion which holds the Sales Order Header Data in Oracle Fusion.
How To Fetch (Query) The Payment Details In Fusion
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.
LoV Queries: Legal Entity, Business Unit, Inventory, Sub Inv.
Queries to create Dependent/ independent LoV queries in Oracle Fusion Report for : Business Unit, Legal Entity, Inventory, sub inventory
Accounting Reconciliation In Oracle Fusion Finance
If you ever work on any fusion finance project, it is a matter of time that you'll be asked to provide accounting related data (most probably for reconciliation). For that you need to combine the data from various sources say AP Invoice, AR Invoice etc. To write such query, one needs to be familiar with… Continue reading Accounting Reconciliation In Oracle Fusion Finance