BWC Error In Line Details Tab For Approved Order When Using French Language (Doc ID 1939491.1)

Last updated on APRIL 13, 2017

Applies to:

Oracle Purchasing - Version 12.2.3 and later
Information in this document applies to any platform.

Symptoms

On Applications 12.2.3 :
In French language, When attempting to go to lines details tab for approved POs from Buyer Work Center ( BWC ) , the following error occurs.

-- Error
Exception Details.
 oracle.apps.fnd.framework.OAException: java.sql.SQLException: ORA-06502: PL/SQL : erreur numérique ou erreur sur une valeur: tampon de chaîne de caractères trop petit
ORA-06512: à "APPS.PO_LINES_SV", ligne 471
ORA-06512: à ligne 2

at oracle.apps.fnd.framework.OAException.wrapperInvocationTargetException(OAException.java:996)
at oracle.apps.fnd.framework.server.OAUtility.invokeMethod(Unknown Source)
at oracle.apps.fnd.framework.server.OAApplicationModuleImpl.invokeMethod(OAApplicationModuleImpl.java:733)
at oracle.apps.po.common.webui.ClientUtil.executeServerCommand(ClientUtil.java:152)
at oracle.apps.po.document.common.webui.DocumentLineBaseCO.processRequestForLines(DocumentLineBaseCO.java:757)
at oracle.apps.po.document.order.webui.OrderLinesCO.processRequest(OrderLinesCO.java:72)
at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequest(OAWebBeanHelper.java:631)
at oracle.apps.fnd.framework.webui.OAWebBeanContainerHelper.processRequest(OAWebBeanContainerHelper.java:252)
at oracle.apps.fnd.framework.webui.beans.layout.OAStackLayoutBean.processRequest(Unknown Source)
at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(OAWebBeanHelper.java:1003)
at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(OAWebBeanHelper.java:970)
at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequest(OAWebBeanHelper.java:690)

.....
.....
## Detail 0 ##
java.sql.SQLException: ORA-06502: PL/SQL : erreur numérique ou erreur sur une valeur: tampon de chaîne de caractères trop petit
ORA-06512: à "APPS.PO_LINES_SV", ligne 471
ORA-06512: à ligne 2

at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:462)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:405)
at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:931)
at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:481)
at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:205)
at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:548)
at oracle.jdbc.driver.T4CCallableStatement.doOall8(T4CCallableStatement.java:213)
at oracle.jdbc.driver.T4CCallableStatement.executeForRows(T4CCallableStatement.java:1111)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1488)
at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3769)
at oracle.jdbc.driver.OraclePreparedStatement.execute(OraclePreparedStatement.java:3954)
at oracle.jdbc.driver.OracleCallableStatement.execute(OracleCallableStatement.java:9353)
at oracle.jdbc.driver.OraclePreparedStatementWrapper.execute(OraclePreparedStatementWrapper.java:1539)
at weblogic.jdbc.wrapper.PreparedStatement.execute(PreparedStatement.java:99)
at oracle.apps.po.common.server.PoCallableStatement.execute(PoCallableStatement.java:297)

....
....

-- What is working
 This is working fine for English login
Also this is working fine in Forms based application.
Moreover, this was working fine R 12.1.1

Steps To Reproduce

---------------------------
1. Login to the application using French language via PO responsibility.
2. Navigate to Buyers workcenter and query for existing approved POs
3. Try to open the PO and click on lines tab, the error will occur.

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