R12: APP-SQLAP-10000: ORA-01403: no data found ccured in APXINWKB When Trying To Perform Actions On A Paid Invoice
(Doc ID 1395035.1)
Last updated on JUNE 07, 2021
Applies to:Oracle Payables - Version 12.0.6 to 12.0.6 [Release 12.0]
Information in this document applies to any platform.
Unable to perform new actions on a paid invoice.
When user clicks on [Actions] for a paid invoice in the Invoice Workbench, the following error occurs.
Error APP-SQLAP-10000: ORA-01403: no data found occurred in
-> AP_ACCOUNTING_EVENTS_PKG.UPDATE_INVOICE_EVENT_STATUS with parameters
(p_invoice_id = #####).
Upon review of APList for the invoice, this is missing the record of its payment in table AP_Checks_All.
The issue can be reproduced at will with the following steps:
- Log into the application using a Oracle Payables responsibility.
- Enter the Invoice Workbench (N)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