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

Last updated on APRIL 04, 2025

Applies to:

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.

Changes

Cause

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