Oracle Error ORA-12713: Character data loss in NCHAR/CHAR conversion

Oracle Error Message

ORA-12713: Character data loss in NCHAR/CHAR conversion

Reason for the Error

When character set conversion happens between CHAR and NCHAR either implicitly or explicitly, some characters are lost due to no mapping characters in the destination character set.

Solution

Make sure all the characters can be mapped to destination character set or set NLS_NCHAR_CONV_EXCP to be FALSE.