We are in Apps9 Update 13. When using Mass Update Shop Order structure on a SO assembly part with 20+ characters, the job errors. It’s fine with 18 or 20 but over 20 and it falls down.
ORA-06502: PL/SQL: numeric or value error: character string buffer too small
ORA-06512: at "IFSAPP.SHOP_ORD_UTIL_API", line 11747
ORA-06512: at "IFSAPP.SHOP_ORD_UTIL_API", line 11792
ORA-06512: at line 1
ORA-06512: at "IFSAPP.TRANSACTION_SYS", line 1454
ORA-06512: at "IFSAPP.TRANSACTION_SYS", line 692
ORA-06512: at "IFSAPP.SHOP_ORD_UTIL_API", line 11747
ORA-06512: at "IFSAPP.SHOP_ORD_UTIL_API", line 11792
ORA-06512: at line 1
ORA-06512: at "IFSAPP.TRANSACTION_SYS", line 1454
ORA-06512: at "IFSAPP.TRANSACTION_SYS", line 692
ORA-06512: at "IFSAPP.TRANSACTION_SYS", line 1239
Is this a ‘known known’, does anyone know? Is there a bug fix at all? Anyone else encounter this? I can’t believe we’re the only company with part numbers between 21 and 25 characters.
Any info/suggestions gratefully received.
Thanks
Linda
Best answer by Björn Hultgren
View original
