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
Remove Trailer record from file during Stage Read Operation — 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

Remove Trailer record from file during Stage Read Operation

Accepted answer
12
Views
2
Comments
edited Sep 11, 2021 9:57PM in Integration 2 comments

Summary

Need to remove trailer record which is of different format than other records from txt file using stage read operation (ICS fails with error "Error while reading native data")

Content

Hello,

I have a requirement where I need to remove the trailer record from a text file at the time of reading it. The trailer record is not of the same format as other records, it has fewer columns. The sample file is attached.

ICS Read operation is failing with error "Error while reading native data.".

Do we have a way where Stage Read operation can read a row with a different format and truncate it?

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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