Thank you for supporting the Cloud Customer Connect Community in 2024. It's a gift to work with you!

Look back
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

PLS-00172: string literal too long while loading BICC PVO data using ODI Marketplace

in Data Integration 3 comments

Summary:

We are trying to load data from Fusion BIACM JournalEntryLinePVO into ADW using ODI-Marketplace. This Job fails with below error.

ERROR

-----------

ODI-1590: The execution of the script failed.

Caused By: javax.script.ScriptException: javax.script.ScriptException: java.sql.SQLException: ORA-06550: line 6, column 15:

PLS-00172: string literal too long

The reason for this issue is because of the number of files those got created by Fusion BIACM in the object storage. Source has 633 million records. Because of this more than 400 files for the PVO getting created in the Object storage. ODI-M mapping is failing due to the huge number of files.

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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