Upgrade R12 : cebucopy.sql fails
Upgrade R12 : cebucopy.sql fails
During R12 upgrade, worker running cebucopy.sql fails with the following error shown in the adworker log:
Start time for file is: Thu Jun 28 2012 16:48:12
sqlplus -s APPS/***** @/oracle/R12/apps/apps_st/appl/ce/12.0.0/patch/115/sql/cebucopy.sql
DECLARE
*
ERROR at line 1:
ORA-12899: value too large for column "AR"."HZ_PARTIES"."HOME_COUNTRY" (actual:
7, maximum: 2)
ORA-06512: at line 925
Due to doc [ID 560504.1], we raised SR , and see that we have many null data returned with below sql:
select bank_name ,description,country
from apps.ap_bank_branches where country is null -- 2820 null rows returned
During R12 upgrade, worker running cebucopy.sql fails with the following error shown in the adworker log:
Start time for file is: Thu Jun 28 2012 16:48:12
sqlplus -s APPS/***** @/oracle/R12/apps/apps_st/appl/ce/12.0.0/patch/115/sql/cebucopy.sql
DECLARE
*
ERROR at line 1:
ORA-12899: value too large for column "AR"."HZ_PARTIES"."HOME_COUNTRY" (actual:
7, maximum: 2)
ORA-06512: at line 925
Due to doc [ID 560504.1], we raised SR , and see that we have many null data returned with below sql:
select bank_name ,description,country
from apps.ap_bank_branches where country is null -- 2820 null rows returned
Tagged:
0