Query to find out the charts of account structure in Oracle Fusion Finance and corresponding value sets.
Tag: Fusion
Report Job Parameters Query in Oracle Fusion
Once you have gone live in fusion, you are bound to have many reports scheduled and there will be a day when the most often run report will do something funky and you would like to run a query to fetch you all the report job parameters. this query will serve the purpose: Query to… Continue reading Report Job Parameters Query in Oracle Fusion
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
Query to find users having a particular Module Access
As it happened to us, we went live on Oracle Fusion Finance and eventually storm passed. Till one day we got a love letter from Oracle telling us that we have granted module access to more users than we have license for. So wasted many man hours in trying to identify the user and their… Continue reading Query to find users having a particular Module Access
BI users: SQL to find them in Oracle Fusion
well... we went live couple of years ago and things had settled down considerably. Till one day we got a notification that few licensing conditions have been violated. so we opened our Purchase Order with Oracle and started finding the various limitations of our license agreement. Apparently there are only a finite number of users… Continue reading BI users: SQL to find them in Oracle Fusion