PLS-00172: string literal too long while loading BICC PVO data using ODI Marketplace
We are trying to load data from Fusion BIACM JournalEntryLinePVO into ADW using ODI-Marketplace. This Job fails with below 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.