Hi all,
We are planning to replicate the Fusion GL screen in Oracle APEX as read-only screens. Basically, it's kind of an Inquiry tool to view all GL data in real-time mode. We have gone through a lot of POC, like creating a new BIP report and getting the data via SOAP calls and inserting it into the APEX database tables, then showing the data as a report on the screen, but it consumes a lot of time and table space too. So we changed our approach to REST API and created a new Rest data source and showed the data directly in an Interactive Grid. It will fulfill our need, but there are a lot of restrictions in the REST approach. The list of restrictions or issues we faced is mentioned below.
- We cannot merge two rest calls in a single report. Do we have any options to achieve two Rest calls and merge the data without inserting it into the tables? We are expecting the direct rest call from the Report region, and the source of the report is Rest Data Source.
- How to pass the additional filter in the Dynamic List of Values using Rest Data Source.
- Most of the Rest calls don't have the Unique ID columns like JeHeaderID. So we cannot communicate with the child data for the particular Header.
Please advise as a good approach in terms of solution perspective. Looking for good solutions.
Thanks in advance…