My Oracle Support Banner

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

Last updated on APRIL 04, 2025

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

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
Goal
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.