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
Million Knowledge Articles and hundreds of Community platforms