OIC 3.0: Delay in processing large XML from OTBI – How to improve performance?

Summary:

Hi community,

I'm looking for ideas or best practices to improve the performance of an integration in Oracle Integration Cloud (OIC v3.0) that is currently taking too long to process data.

Let me briefly explain the scenario:

The flow starts by calling a report in OTBI, which returns an XML file with approximately 1,000 lines.

The integration then decodes the XML and enters a for-each loop, where each line is processed individually and an insert is made into a database table using a PL/SQL procedure.

This flow currently takes about 3 minutes, which seems excessive and is a concern given potential increases in data volume, as it could fail or exceed OIC time limits.