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.
Goal
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, adgendbc.sh 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
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, adgendbc.sh 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
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 |