About This Recipe
This recipe extracts BI Publisher (BIP) report data from Oracle ERP Cloud in an asynchronous manner and uploads the data to an FTP server.
To use the recipe, you must install the recipe and configure the connection and other resources within it. The integration uses a scheduled orchestration pattern so that you can schedule when to extract the data and how often. The extracted reports are then uploaded to an FTP server. The reports are available to users and applications directly from the FTP location. If required, you can enrich or edit the extracted report data within the integration.
- Queries bulk data from Oracle ERP Cloud.
- Receives the data via the ERP trigger.
- Invokes it through the SOAP adapter and gets the data from a business event.
- Completes the process. If the export completes successfully as per the Oracle ERP Cloud callback, then uploads the file received in the callback to the FTP server. If the export fails, then sends an email notification.
You can upload the extracted reports to File Server, an embedded sFTP server within Oracle Integration. To use File Server, you must enable it for your Oracle Integration instance. See Enable File Server in Using File Server in Oracle Integration 3.