How to Convert Database Character Set in Oracle EBS R12.2.7 from US7ASCII to AL32UTF8
Hello,
My Oracle EBS installation is on US7ASCII. For Oracle Hyperion integration, the database character set need to be converted to AL32UTF8.
I have converted using
shutdown immediate;
startup restrict;
alter database character set internal_use AL32UTF8;
alter database character set AL32UTF8;
shutdown immediate;
startup;
I have updated the context file for the database and the application and ran autoconfig and all of that completed successfully.
The challenge now is that when i open Oracle apps form and try to query for data or pick from the list of values, the form will just close with form server error message.