Oracle Solution for Error ora-12713

Solution for Oracle Error ORA-12713

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

What triggered 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.

What should we do to fix it:

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