R12:AP: Perform Actions on a Paid Invoice Gives Error: APP-SQLAP-10000: ORA-01403: no data found occured in APXINWKB
(Doc ID 1395035.1)
Last updated on AUGUST 12, 2022
Applies to:Oracle Payables - Version 12.0.6 to 12.2 [Release 12.0 to 12.2]
Information in this document applies to any platform.
Unable to perform new actions on a paid invoice.
In the Invoice Workbench, query up a paid invoice, click on [Actions] and get the following error:
Error APP-SQLAP-10000: ORA-01403: no data found occurred in
-> AP_ACCOUNTING_EVENTS_PKG.UPDATE_INVOICE_EVENT_STATUS with parameters
(p_invoice_id = #####).
The issue can be reproduced at will with the following steps:
- Navigate to the Oracle Payables responsibility.
- Enter the Invoice Workbench and go to Invoices > Entry> Invoices.
- Query a paid invoice.
- Try to do any action against the invoice.
- The error raises.
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