R12: AP Objects - Character Set Conversion Exceptions WE8ISO8859P1 > AL32UTF8 (Doc ID 2120585.1)

Last updated on MARCH 25, 2016

Applies to:

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

Goal

1. Upgrading E-Business Suite 11.5.10.2 to R12 and migrating platforms from Red Hat Linux 5 to Oracle Solaris Sparc (SuperCluster).

2. The goal is   performing a character set conversion at Release 12.1.3 of E-Business Suite. The current database character set is WE8ISO8859P1 and the Target Character Set is AL32UTF8.
Have run the ‘Data Migration Assistant for Unicode’ (version 2.1) to perform the scan and subsequent conversion.
There a number of AP objects with Expansion exceptions, which must be addressed, prior to the conversion. The Data migration Assistant for Unicode tool identifies the problem rows by row_id.

3. Are direct table updates on the object.column_names listed below fully supported by Oracle?

Owner Object_name      Column_name

---------------------------------------------------------           
AP_AE_HEADERS_ALL    DESCRIPTION      
AP_AE_LINES_ALL    DESCRIPTION         
AP_INVOICES_ALL    DESCRIPTION           
AP_INVOICE_DISTRIBUTIONS_ALL   
AP_INVOICE_DISTRIBUTIONS_ALL 

AP_INVOICE_DISTS_ARCH.DESCRIPTION
AP_INVOICE_DISTS_ARCH.JUSTIFICATION
AP_INVOICE_LINES_ALL.DESCRIPTION
AP_INVOICE_LINES_ALL.ITEM_DESCRIPTION
AP_INVOICE_LINES_ALL.JUSTIFICATION




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