Oracle Solution for Error ora-30389

ORA-30389: the source statement is not compatible with the destination statement

What triggered the Error:

The SELECT clause of the source statement is not compatible with the SELECT clause of the destination statement

What should we do to fix it:

Verify both SELECT clauses are compatible with each other such as numbers of SELECT list items are the same and the datatype for each SELECT list item is compatible