How to Update Data in SY_ADDR_MST in Release 12 (Doc ID 2051538.1)

Last updated on MARCH 08, 2017

Applies to:

Oracle Process Manufacturing Systems - Version 12.1.3 and later
Information in this document applies to any platform.

Goal

Customer on 12.1 (migrated from 11i) is trying to migrate their data to a new character set, Unicode (UTF-8). They have a tool to identify data that will be a problem for conversion, and it has found that they have several rows in sy_addr_mst in which state_code = Łódz, and when this is converted to Unicode it will be six characters long but the column only allows four characters. They are asking where in the application they can go to change this value.
 

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