Problem Converting Oracle EBS Purchasing Data To UTF8 (multi-byte) Characterset

(Doc ID 2163125.1)

Last updated on JULY 20, 2016

Applies to:

Oracle Purchasing - Version 12.1.3 and later
Information in this document applies to any platform.

Goal

 Problem converting Oracle EBS database to UTF8 (multi-byte) characterset (PO)

We are currently in an exercise to convert our Oracle EBS database from
Western European to UTF8 (multi-byte) characterset to support Asian Languages
as part of the business requirements.


As part of the exercise, the DBCS scanning reveals that we have about 120K
number of records across different tables which failed due to the size of the
data value exceeding the respective table column size after conversion.

Will Purchasing development provide a data fix script?

Solution

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms