Tag: query

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,, Business Unit structure, Enterprise structure, security

LoV Queries: Legal Entity, Business Unit, Inventory, Sub Inv.

Mohit Saxena

Queries to create Dependent/ independent LoV queries in Oracle Fusion Report for : Business Unit, Legal Entity, Inventory, sub inventory

BI Report, Business Intelligence Report,, Oracle Fusion, security

Business Unit – Legal Entity – COA (Charts Of Accts) SQL

Mohit Saxena

Brief Idea about Oracle Fusion Business Unit, Ledger and Legal entity relationship and the query to fetch the values

BI Report, Business Intelligence Report,, Oracle Fusion, Oracle Fusion Finance

Accounting Reconciliation In Oracle Fusion Finance

Mohit Saxena

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