While Registering a Supplier Get Errors In Products And Services Category Setup like ORA-06520 character string buffer too small, and ORA-06512 at POS_PRODUCT_SERVICE_UTL_PKG line 240 and line 362 (Doc ID 1915170.1)

Last updated on JUNE 08, 2017

Applies to:

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

Symptoms

In 12.1.3 Supplier Lifecycle Management / iSupplier Portal

Get errors ORA-06520 character string buffer too small, and ORA-06512 at POS_PRODUCT_SERVICE_UTL_PKG line 240 and line 362 in Products and Services Category Setup page when trying to Register a Supplier

ERROR

1. 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 240 ORA-06512: at "APPS.POS_PRODUCT_SERVICE_UTL_PKG", line 362 ORA-06512: at "APPS.POS_PRODUCT_SERVICE_UTL_PKG", line 743 ORA-06512: at line 1
2. The Products & Services category setup is a one time event.

 

Exception Details.
oracle.apps.fnd.framework.OAException: 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 240 ORA-06512: at "APPS.POS_PRODUCT_SERVICE_UTL_PKG", line 393 ORA-06512: at line 1
at oracle.apps.fnd.framework.OAException.wrapperException(OAException.java:912)
at oracle.apps.fnd.framework.OAException.wrapperException(OAException.java:886)
at oracle.apps.fnd.framework.OAException.wrapperInvocationTargetException(OAException.java:1009)
at oracle.apps.fnd.framework.server.OAUtility.invokeMethod(OAUtility.java:211)
at oracle.apps.fnd.framework.server.OAUtility.invokeMethod(OAUtility.java:153)
at oracle.apps.fnd.framework.server.OAApplicationModuleImpl.invokeMethod(OAApplicationModuleImpl.java:762)
at oracle.apps.pos.profile.webui.PSDefSetupCO.processFormRequest(PSDefSetupCO.java:69)
at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processFormRequest(OAWebBeanHelper.java:827)
at oracle.apps.fnd.framework.webui.OAWebBeanContainerHelper.processFormRequest(OAWebBeanContainerHelper.java:385)
at oracle.apps.fnd.framework.webui.OAPageLayoutHelper.processFormRequest(OAPageLayoutHelper.java:1206)
...
## 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 240 ORA-06512: at "APPS.POS_PRODUCT_SERVICE_UTL_PKG", line 393 ORA-06512: at line 1
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:439)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:395)
at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:802)
at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:436)
at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:186)
at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:521)
at oracle.jdbc.driver.T4CCallableStatement.doOall8(T4CCallableStatement.java:202)
at oracle.jdbc.driver.T4CCallableStatement.executeForRows(T4CCallableStatement.java:1005)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1307)
at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3449)
at oracle.jdbc.driver.OraclePreparedStatement.execute(OraclePreparedStatement.java:3550)
at oracle.jdbc.driver.OracleCallableStatement.execute(OracleCallableStatement.java:4710)
at oracle.jdbc.driver.OraclePreparedStatementWrapper.execute(OraclePreparedStatementWrapper.java:1374)
at oracle.apps.pos.profile.server.PSSetupAMImpl.validatePSProfile(PSSetupAMImpl.java:158)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:597)
at oracle.apps.fnd.framework.server.OAUtility.invokeMethod(OAUtility.java:190)
at oracle.apps.fnd.framework.server.OAUtility.invokeMethod(OAUtility.java:153)
at oracle.apps.fnd.framework.server.OAApplicationModuleImpl.invokeMethod(OAApplicationModuleImpl.java:762)
at oracle.apps.pos.profile.webui.PSDefSetupCO.processFormRequest(PSDefSetupCO.java:69)
at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processFormRequest(OAWebBeanHelper.java:827)
...


STEPS TO REPRODUCE
1. Navigate to Supplier Management Admistrator -> Supplier Home -> Administartion->Registration
2. Click Products and Services
3. Choose Categories and click Apply
After clicking apply.get the Error and Exception details


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