Excel Update Fails To Update The WIP Supply Type On Items

(Doc ID 1903209.1)

Last updated on OCTOBER 28, 2015

Applies to:

Oracle Product Hub - Version 12.1.3 and later
Information in this document applies to any platform.


When trying to update the WIP Supply Type using Excel Import, the following error occurs. The Excel import works fine for User Defined Attributes and also works fine for other operation attributes besides the WIP Supply Type.

Error : -6502---ORA-06502: PL/SQL: numeric or value error: character string buffer too small

The issue can be reproduced at will with the following steps:
1. Search for an item in PIM Item Search. Ensure that the display format captures the WIP Supply Type of the item.
2. Export the item.
3. Update the WIP Supply Type
4. Import the changed data


Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms