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
Tag: Oracle Training
Job details Query in Oracle Fusion
Query to find the details of Fusion Job Reports such as start date, end date, status, report path ( where report resides).
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
Report Security: Data Access On Specific Entities
How to restrict the data access of users in Fusion Report to limit the input parameters in order to maintain the data privacy