My Oracle Support Banner

R12: AP: Invoice Number Field On Payables (AP) Invoice Form, Accepting Only 45 Characters. Receiving Error "Maximum Length of Field is 45 Characters" or "User-Defined Exception Occurred in AP_FUNDS_CONTROL_PKG.Funds_Check" (Doc ID 2016221.1)

Last updated on FEBRUARY 28, 2024

Applies to:

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



The Invoices Workbench will not allow the entry of invoices with invoice numbers greater than 45 characters, even though the INVOICE_NUM column in table AP_INVOICES_ALL would allow 50 characters.

Entering an invoice number greater than 45 characters generates  errors like

1 A message on the Invoices Entry form:

 "Maximum Length of field is 45 characters"


2. When trying to check funds on a specific invoice:

APP-SQLAP-10000: User-Defined Exception occurred in AP_FUNDS_CONTROL_PKG.Funds_check<-Funds_check_processor<-APXINWKB<-INV_SUM_FOLDER_BLOCK_UTIL with parameters (invoice_id= XX) while performing the following operation.



1. Payables Responsibility,
2. Invoice\Entry\Invoices
3. Enter an invoice or query an existent invoice with the Inv number greater than 45 Characters.


To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

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