Oracle Error ORA-38602: FI invalid input cursor

Oracle Error Message

ORA-38602: FI invalid input cursor

Reason for 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

Solution

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.