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
Error Writing to Stage File in OIC — 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

Error Writing to Stage File in OIC

Received Response
12
Views
3
Comments
edited Nov 27, 2020 7:46AM in Integration 3 comments

Summary

Writing to Stage File Activity throws an Error when all data is filtered out in the Corresponding Map using XSLT

Content

I have a 'Write-to-Stage-File-Activity added to the Integration and I would like to write only the records satisfying a particular condition into the file. Instead of using separate 'For-Each' and 'Switch' activities before the 'Write-to-Stage-File-Activity', I simply put the conditions in the Write-to-Stage-File-Activity's Mapper itself (Map for Write-to-Stage-File-Activity)

In a case or two, there is a possibility that none of the records satisfy the condition in the 'XSLT: if' test and there is no record being created on the target side of the mapper, and when this self-closing parent tag (since there is no record data) is being sent to the 'Write to Stage File' activity it errors out with the error: '

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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