OIC 3.0: Delay in processing large XML from OTBI – How to improve performance? — Cloud Customer Connect
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

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.

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!