My Oracle Support Banner

R12.0: APP-SQLAP-10000: ORA-01403: no data found occured in APXINWKB When Trying To Perform Actions On A Paid Invoice (Doc ID 1395035.1)

Last updated on JANUARY 09, 2018

Applies to:

Oracle Payables - Version 12.0.6 to 12.0.6 [Release 12.0]
Information in this document applies to any platform.

Symptoms

On : 12.0.6 ,

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
-----------------------
Error APP-SQLAP-10000: ORA-01403: no data found occurred in
APXINWKB->INV_SUM_FOLDER_ITEM_OVERFLOW
-> 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.

STEPS
-----------------------
The issue can be reproduced at will with the following steps:

  1. Log into the application using a Oracle Payables responsibility.
  2. Enter the Invoice Workbench (N)Invoices > Entry> Invoices.
  3. Query a paid invoice.
  4. Try to do any action against the invoice.
  5. The error raises.


BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot update Invoice

Changes

 

Cause

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
Symptoms
Changes
Cause
Solution
References


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