R12: Cannot Add A PayGroup With More Than 25 Characters To A Supplier (Doc ID 567369.1)

Last updated on JANUARY 17, 2012

Applies to:

Oracle Payables - Version: 12.0.1 to 12.1.3 - Release: 12.0 to 12.1
Information in this document applies to any platform.

Goal

How to add a PayGroup lookup code larger than 25 characters and assign it to a Supplier?

The lookup code can be entered for only up to 25 characters. If more than 25 characters are entered the following error message will arise:
    ------------
    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_VENDOR_PUB_PKG", line 2398
    ORA-06512: at line 1
    ------------

Solution

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