Drilldown from GL to AR or AP Fails with oracle.apps.fnd.framework.OAException: java.sql.SQLException: ORA-06502: PL/SQL: numeric or value error: character string buffer too small (Doc ID 2782201.1)

Last updated on OCTOBER 12, 2022

Applies to:

Symptoms

When using Drilldown from GL to Accounts Receivable, the drilldown fails with:

ERROR
-----------------------

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 line 1
at oracle.apps.fnd.framework.OAException.wrapperException(OAException.java:912)
at
oracle.apps.xla.linesinquiry.server.JeLinesInqVORowImpl.populateCustomerData(JeLinesInqVORowImpl
.java:922)
at
oracle.apps.xla.linesinquiry.server.JeLinesInqVORowImpl.getCustomerName(JeLinesInqVORowImpl.java
:947)
at
oracle.apps.xla.linesinquiry.server.JeLinesInqVORowImpl.getAttrInvokeAccessor(JeLinesInqVORowImpl.j
ava:2639)
at oracle.jbo.server.ViewRowImpl.getAttribute(ViewRowImpl.java:695)
at oracle.jbo.server.ViewRowImpl.getAttribute(ViewRowImpl.java:760)
at
oracle.apps.fnd.framework.webui.OADictionaryDataRow.selectGoodValue(OADictionaryDataRow.java:20



Steps to Reproduce:

Using a General Ledger (GL) Responsibility, menu path:  Inquiry > Account.

1)  Complete GL Period and Account Information

2)  Click the Drilldown button

Error will return for some but not all lines of data in most cases; the unaffected data will display normally.

This same error can occur when drilling to Accounts Payable (with same steps) but can be related to length of the Supplier Name field.

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.