Oracle Error ORA-42016: shape of interim table does not match specified column mapping

Oracle Error Message

ORA-42016: shape of interim table does not match specified column mapping

Reason for the Error

The number of columns, or the type or the length semantics of a column, in the interim table did not match the specified column mapping.

Solution

Ensure that the interim table matches the column mapping by either modifying the column mapping string or altering the interim table’s column definition(s).