AP: Invoice Number Field On Payables (AP) Invoice Form, Accepting Only 45 Characters (Doc ID 2016221.1)

Last updated on APRIL 22, 2023

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:

  "Maximum Length of field is 45 characters"

OR

2. When trying to check funds on a specific invoice

APP-SQLAPP-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.

 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 long.

Changes

Cause

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