After EBS DB Upgrade to 19c : PDB Not In Unicode (AL32UTF8) Character Set. PDB Character Set US7ASCII

Error:

While upgrading EBS Database to 19c PDB violations check (Log File : check_pdb_plugin_violations.out) provides following message,

PDB not in Unicode (AL32UTF8) character set. PDB character set US7ASCII

Or when executing query getting below output

select NAME,CAUSE,TYPE,ERROR_NUMBER,MESSAGE,STATUS,ACTION from PDB_PLUG_IN_VIOLATIONS;

DB not Unicode

WARNING 0

Character set mismatch: PDB character set US7ASCII. CDB character set AL32UTF8.
RESOLVED

Oracle recommends using Unicode (AL32UTF8) character set for the database. Consider migrating the database to Unicode.

Solution:

Check characterset of PDB (EBS Database) and create new CDB with same characterset

select * from nls_database_parameters;

CDB

PARAMETER VALUE

------------------------------ ------------------------------

NLS_RDBMS_VERSION 19.0.0.0.0

NLS_NCHAR_CONV_EXCP FALSE

NLS_LENGTH_SEMANTICS BYTE

NLS_COMP BINARY

NLS_DUAL_CURRENCY $

NLS_TIMESTAMP_TZ_FORMAT DD-MON-RR HH.MI.SSXFF AM TZR

NLS_TIME_TZ_FORMAT HH.MI.SSXFF AM TZR

NLS_TIMESTAMP_FORMAT DD-MON-RR HH.MI.SSXFF AM

NLS_TIME_FORMAT HH.MI.SSXFF AM

NLS_SORT BINARY

NLS_DATE_LANGUAGE AMERICAN

NLS_DATE_FORMAT DD-MON-RR

NLS_CALENDAR GREGORIAN

NLS_NUMERIC_CHARACTERS .,

NLS_NCHAR_CHARACTERSET AL16UTF16

NLS_CHARACTERSET AL32UTF8

NLS_ISO_CURRENCY AMERICA

NLS_CURRENCY $

NLS_TERRITORY AMERICA

NLS_LANGUAGE AMERICAN

PDB