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
Category: Oracle Fusion
Looping Finite Number Of Times in RTF
How to do looping finite number of times in an RTF to repeat a particular layout for a fixed number of times
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
How To Develop an RTF Template
Few useful steps in developing an RTF template in Bi publisher report. RTF template is used to produce output in formats like excel, pdf etc