Java Error ORA-06502: PL/SQL: numeric or value error: character string buffer too small During Setting Products & Services Category In SLM (Doc ID 1916524.1)

Last updated on OCTOBER 20, 2016

Applies to:

Oracle Supplier Lifecycle Management - Version 12.1.3 and later
Information in this document applies to any platform.

Symptoms

On : 12.1.3 version, Miscellaneous

Java Error during Setting Products & Services Category in SLM


ERROR
-----------------------
Exception Details.
 oracle.apps.fnd.framework.OAException: oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: SELECT 'PS:' || code ps_code,
  code,
  meaning
FROM table(pos_product_service_utl_pkg.product_service_ocv)
.
.
## Detail 0 ##
java.sql.SQLException: ORA-06502: PL/SQL: numeric or value error: character string buffer too small
ORA-06512: at "APPS.POS_PRODUCT_SERVICE_UTL_PKG", line 591
ORA-06512: at "APPS.POS_PRODUCT_SERVICE_UTL_PKG", line 2021
ORA-06512: at "APPS.POS_PRODUCT_SERVICE_UTL_PKG", line 2024
ORA-06512: at "APPS.POS_PRODUCT_SERVICE_UTL_PKG", line 2055


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1) Login to "Supplier Management Administrator"
2) Click on Administrator tab and then select " Products & Services Category"
3) Click on search icon for category and java error is displayed

Cause

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