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 OCTOBER 10, 2022

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 Administrator -> Supplier Home -> Administration -> Registration
2. Click Products and Services
3. Choose Categories and click Apply
After clicking apply, get the Error and Exception details

Cause

	To view full details, sign in with your My Oracle Support account.
	Don't have a My Oracle Support account? Click to get started!

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.

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)

Applies to:

Symptoms

Cause

To view full details, sign in with your My Oracle Support account.

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