My Oracle Support Banner

icxwebpf.sql, adwebprf.sql Run During Autoconfig, After Database Characterset Conversion To AL32UTF8 Fail With ORA-22631 (Doc ID 1178790.1)

Last updated on DECEMBER 23, 2023

Applies to:

Oracle E-Business Suite Technology Stack - Version 12.0.4 to 12.0.6 [Release 12.0]
Information in this document applies to any platform.



To convert R12 EBS environment to UNICODE character set.

Converted R12 EBS database environment to character set AL32UTF8 from WE8ISO8859P1. Running autoconfig on the admin/middle tiers resulted in several scripts to  (icxwebprf.sql,adwebprf.sq, etc) fails with the error as follows

ERROR at line 1:
ORA-22631: attribute [ORA-22631: attribute [7] is is not well-formed or does not match the type] is is not well-formed or does not match the type
ORA-06512: at "APPS.WF_EVENT", line 1160
ORA-06512: at "APPS.FND_WF_ENGINE", line 1025
ORA-06512: at "APPS.FND_PROFILE", line 3110
ORA-06512: at "APPS.FND_PROFILE", line 3507
ORA-06512: at "APPS.ADX_PRF_PKG", line 202
ORA-06512: at line 6


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

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