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

What is the best approach to insert report data from oracle fusion to Autonomous DB?

Summary:

Hello,

I am trying to insert the data from a report whose output is in XML format using OIC in which SOAP service is called to retrieve data from report and passed as body to a rest service which calls a procedure developed in Apex to decode the payload and insert into table using XML table functionality.

But when the report data exceeds 5MB (not sure exactly what is the limit), error occurs while inserting.

What is the best approach to insert report data from oracle fusion to Autonomous DB?

Content (please ensure you mask any confidential information):


Version (include the version you are using, if applicable):

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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