Register today for Oracle CloudWorld. October 17th - 20th, Las Vegas

Register now

Hillel Cooperman, Senior VP of User Experience Design, has a message for you on Oracle CloudWorld

Watch now
Issue on writing a file within a foreach loop — 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

Issue on writing a file within a foreach loop

Received Response
17
Views
3
Comments
edited Oct 1, 2020 2:04PM in Integration 3 comments

Content

Hi Experts,

I have created an integration that reads a BI Publisher report, my goal is to put the response of the report inside a foreach loop and using a stage file with an XSD schema to write the response that I will return in the integration. The response it currently returns is the following:

<?xml version="1.0" encoding="UTF-8" ?>
<EXPENSES>
   <FECHA_INICIO>2020-09-01T00:00:00.000+00:00</FECHA_INICIO>
   <FECHA_FIN>2020-09-15T00:00:00.000+00:00</FECHA_FIN>
   <REPORTS>
      <EXPENSE_REPORT_ID>300000009961223</EXPENSE_REPORT_ID>
      <EXPENSE_REPORT_DATE>2020-08-27T00:00:00.000+00:00</EXPENSE_REPORT_DATE>
   </REPORTS>
</EXPENSES>
<?xml version="1.0" encoding="UTF-8" ?>
<EXPENSES>
   <FECHA_INICIO>2020-09-01T00:00:00.000+00:00</FECHA_INICIO>

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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