Technology Stack - EBS (MOSC)

MOSC Banner

How to Convert Database Character Set in Oracle EBS R12.2.7 from US7ASCII to AL32UTF8

edited Jun 26, 2019 7:09PM in Technology Stack - EBS (MOSC) 5 commentsAnswered ✓

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.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center