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:

Symptoms

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:

OR

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

 Steps:

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

Cause

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