Queries to create Dependent/ independent LoV queries in Oracle Fusion Report for : Business Unit, Legal Entity, Inventory, sub inventory
Tag: Fusion Report
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
Report Security Set Up In Oracle Fusion
How to secure the reports in Fusion to give access to specific users or roles and how to manage the actions they can perform like scheduling
Report Scheduling – For Specific timings over the days
Report scheduling to run the only during business hours i.e. report must trigger every 10 minutes between 7:30 AM and 5:30 PM on weekdays. Now if you have scheduled a report in Oracle Fusion, you would know that one can very easily schedule the report to run periodically and you can define for how many… Continue reading Report Scheduling – For Specific timings over the days
SFTP Bursting to Split and Deliver the File
How to enable SFTP bursting in Oracle Fusion to split and send the file to multiple SFTP servers and how to split the file differently