I got below error during BIAPPS full load:
ODI-1228:Task SIL_APTransactionFact_Reverse_DiffManLoad.W_AP_XACT_F(Integration) fails on the target ORACLE connection BIAPPS_DW.
Cause By:Java.sql.SQLsyntaxErrorException: ORA-01892:maxium of columns in a table or view is 1000.
Please let me know how to proceed forward. This table don't have that many columns.
Thanks for your quick response.
What is the Oracle version for connection BIAPPS_DW? Is it 12c? If yes, then the following could help:
Oracle 12c: ORA-01792 but not in Oracle 11g