While Following Note:124721.1 to Perform Character Set Conversion WE8ISO8859P1 to AL32UTF8 Or UTF8 Get Exceptions on GL data

(Doc ID 2062409.1)

Last updated on SEPTEMBER 19, 2016

Applies to:

Oracle General Ledger - Version 11.5.10.2 and later
Information in this document applies to any platform.

Symptoms

When performing a Database Character Set Conversion to Unicode (UTF-8) using Oracle Database Migration Assistant for Unicode (DMU), some data in the General Ledger tables has expanded beyond the length of its column width when converting to Unicode.
This data needs to be shortened before the conversion can take place.

The affected data can include the following :-

 
TABLE COLUMN FIX
GL_JE_BATCHES NAME Unposted Journals can be fixed via the forms: Journals > Entry
Posted journals need a datafix - log an SR
GL_JE_HEADERS NAME, DESCRIPTION Unposted Journals can be fixed via the forms: Journals > Entry
Posted journals need a datafix - log an SR
GL_JE_LINES DESCRIPTION, REFERENCE_1, REFERENCE_5 Unposted Journals can be fixed via the forms: Journals > Entry
Posted journals need a datafix - log an SR
GL_IMPORT_REFERENCES REFERENCE_1, REFERENCE_5 Needs a datafix - log an SR
RG_REPORT_STANDARD_AXES_TL STANDARD_AXIS_NAME Needs a datafix - log an SR
GL_REVALUATIONS NAME Needs a datafix - log an SR
GL_ALLOC_BATCHES NAME Fix via the form: Journals > Define > Allocation
GL_ALLOC_FORMULAS NAME Fix via the form: Journals > Define > Allocation, query allocation, click on Formulas button
GL_ALLOC_HISTORY NAME Needs a datafix - log an SR
GL_JE_CATEGORIES_TL USER_JE_CATEGORY_NAME Fix via the form: Setup > Journal > Categories
GL_RECURRING_BATCHES NAME May be possible to fix via the form but datafix given
GL_RECURRING_HEADERS NAME May be possible to fix via the form but datafix given
GL_INTERFACE REFERENCE10 Fix via the form: Journal > Import > Correct. References tab

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Cause

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