Hello everyone,
I am currently working on generating a BI Publisher report where the data is being retrieved from two different sources:
- A REST API, which returns a JSON response.
- Oracle Fusion Cloud, using a standard data model or SQL-based dataset.
These datasets are currently separate, and I need to consolidate the data from both sources into a single unified BI Publisher report. The key requirement is to align the REST API response with the Oracle Fusion Cloud data, ensuring that both are presented in a consistent and integrated format within the report.
I have attached a screenshot showing the sample responses from both the REST API and the BIP report for reference.
Example scenario:
I am working with two different data sources that need to be consolidated for reporting purposes:
- REST API Response:
Includes the following columns:
- Customer (e.g., 1234)
- Item (e.g., 100050)
- GLCode (e.g., 10-Meat)
- Oracle Fusion Cloud Data Set:
Includes the following columns:
- Customer (e.g., 1234)
- Item (e.g., 100050)
- Additional transactional or master data fields
The combination of Customer and Item serves as the common key between both data sets.
Objective:
I need to fetch the GL Code from the REST API and align it with the corresponding records from Oracle Fusion Cloud, based on the Customer–Item combination. The final output should be a single consolidated BI Publisher report that merges relevant data from both sources using this common key.