Utilize Visual Builder Studio To Streamline File Upload, ESS Submission and Output Download

Business Need

In one of our previous posts Oracle Fusion SaaS BIP Report: Combine SQL reports with user’s manually uploaded files, we demonstrated a method for end users to upload a file and use an ESS job to run a report that combines the uploaded file with data from Oracle Fusion SaaS.

This technique allows incorporating user-uploaded data into Fusion calculations, but it involves several steps:

1. Upload a file via the File Export/Import screen by selecting a specific account and a local file.
2. Use the standard ESS Job submission screen to run the report, selecting the recently uploaded file (identified via the revisions table and the currently connected user; the list can be lengthy).
3. Wait for job completion (refresh while running).
4. Open the output using the standard output download for an ESS job.

Our customer requested a simplification of this process: using a single screen to select the file without choosing an account, submit the ESS job, and view the results on the same screen without navigating to the ESS monitor screen.

Solution Overview

We implemented a solution in a new AppUI within Visual Builder Studio, utilizing the following approach:

1. Enable the user to upload a local file and set values for additional report parameters.
2. Upload the file to UCM (similar to File Export/Import) using the /fscmRestApi/resources/erpintegrations FSCM REST endpoint to a specific account, without requiring the user to select it via UI.
   
3. Use /rest/scheduler/v1/requests to submit the ESS job.
   
4. Use a JavaScript interval to monitor job completion via /rest/scheduler/v1/requests endpoints.
   
5. Use /rest/scheduler/v1/requests to fetch the BIP job ID for the completed ESS.
   
6. Use /xmlpserver/services/ScheduleReportWSSService to calculate the BIP Output ID for the BIP Job ID.
   
7. Use /xmlpserver/services/ScheduleReportWSSService to download the actual BIP result file.
   SOAP Request for BIP download:
   
   
   Helper function:
   

Summary

This new approach significantly improves user efficiency by eliminating multiple clicks and screen navigations. The single-screen interface streamlines the entire workflow, from file upload to viewing results, making it more intuitive and time-saving for end users working with Oracle Fusion SaaS reports.