Invoice Workbench Errors With APP-SQLAP-1000: ORA-01403 (Doc ID 1279522.1)

Last updated on MARCH 08, 2017

Applies to:

Oracle Payables - Version: 12.0.4 and later   [Release: 12.0 and later ]
Information in this document applies to any platform.

Symptoms

The invoice entry form was not allowing any updates on a particular invoice. Receiving the following error when trying to manage a particular invoice.

APP-SQLAP-1000: ORA-01403: no data found ocurred in
APXINWKB->INV_SUM_FOLDER_ITEM_OVERFLOW -> AP_ACCOUNTING_EVENTS_PKG.UPDATE_INVOICE_EVENTS_STATUS 

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