Skip to Main Content

General Development Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

OIC: Read File From UCM Using Oracle Integration Cloud

Hi All,

I want to read file from ucm and insert data inside it to DB, and i already create custom ess job

i used ERP adapter to export bulk data and provide the custom ess job name then, in callback use ERP adapter to get document by document id received from export bulk data,

when i try to unzip file or stage the file by decode the response value “content” give me an error

when staging below error:

“Error occurred while processing activity readEntireFilesf0. Error : SAX Exception in translator.
SAX Exception raised while trying to SAX Parse InputStream .
Please make sure that the xml data is valid.”

when try to unzip below error:

“Error occurred while processing activity unzipsf1. Error : java.io.IOException: The file to be unzipped [/ocid1_integrationinstance_oc1_me_abudhabi_1_amaaaaaadh73biyanjcwrzfhtxkmpuoln7srytelusfhvad473vfl2nontna/SRxx0ER0Ee67Qb92vK7heQ/UEsDBBQACAgIAMcGG1cAAAAAAAAAAAAAAAALAAAAMTE5MDAxMC5sb2eFUl1r2zAUffevuJDHUVtWEpIaBknzUbK5sbHdQVeKUazrVNSWMkvqkn8/OWtH17FNT9LVOYd77j2DwWBwTwkdXpDpBZ0UdBSNRxEJ/emIfiAkIuQB7jfbdfI……..”

– i have tried to send file (by decode “content value”) it send in format attached :

appreciate your support

oic err1.png

oic err2.png

Comments
Post Details
Added on Aug 27 2023
2 comments
1,330 views