R12: Unable to Match PA Related Invoice to PO due to APP-SQLAP-10000 and ORA-06502 Error Messages

(Doc ID 1520290.1)

Last updated on JUNE 14, 2016

Applies to:

Oracle Payables - Version 12.0.1 and later
Information in this document applies to any platform.

Symptoms

When attempting to match invoice to PO the following error occurs.
    -------
    APP-SQLAP-10000: ORA-06502: PL/SQL: numeric or value error: character string buffer too small occurred in AP_MATCHING_UTILS_PKG.IS_PROJ_EXP_ITEM_DATE_VALID

Steps to reproduce
---------------------
1) From Purchasing: create a PO with projects.
2) From Payables: match this PO to invoice.


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