Hi All,
We have used LKM BICC to ADW Copy KM to load the Fusion PVO extract data from Object storage to Oracle Database.
We have observed one of the source PVO column data type is VARCHAR2(4000) but actual data length is more than 4000.
In LKM BICC to ADW Copy has an option called TRUNCATE_COLUMNS (Description : If the data in the file is too long for a field, then this option will truncate the value of the field rather than reject the row.).
We have enabled this Option to truncate the value. but when we try to run the ODI mapping it got failed with "ORA-20003: Reject limit reached, query table "<USER>"."COPY$146974_LOG" for error details"
In Executed Code we have checked 'truncatecol' VALUE 'true'.
When we check COPY$146974_LOG table found actual value length higher than the column length issue.
Any suggestion.
Thanks in advance.