R12: Unable to Match PA Related Invoice to PO due to APP-SQLAP-10000 and ORA-06502 Error Messages
Last updated on JUNE 14, 2016
Applies to:Oracle Payables - Version 12.0.1 and later
Information in this document applies to any platform.
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.
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