Skip to main content

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

This is a bug. A made a quick search and I believe it was corrected with patch 146216 on apps 9.


Thanks, @Björn Hultgren  Much appreciated.

 

Now have the challenge of getting hold of the patch and have it applied to our environment.

 

Linda


Reply