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 FEBRUARY 03, 2019
Applies to:
Oracle General Ledger - Version 11.5.10.2 and laterInformation 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
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
| Symptoms |
| Cause |
| Solution |
| References |