Oracle Solution for Error ora-38602

Solution for Oracle Error ORA-38602

ORA-38602: FI invalid input cursor

What triggered the Error:

The input cursor did not return exactly two columns for transactional input format or the input cursor didn't have consistent data types for horizontal input format

What should we do to fix it:

For transactional input format, specify that the input cursor returns exactly two columns: one for transaction-id, one for item-id. For horizontal input format, make sure the input cursor's columns have the same data types.