R12: Error APP-SQLAP-10000 ORA-01403 While Trying To Cancel Invoice (Doc ID 1640983.1)

Last updated on AUGUST 30, 2016

Applies to:

Oracle Payables - Version 12.1.1 to 12.2.4 [Release 12.1 to 12.2]
Information in this document applies to any platform.

Symptoms

Oracle R12.1.3
When attempting to cancel an invoice, the following error occurs.

ERROR
-----------------------
Error:
APP-SQLAP-10000: ORA-01403: no data found occurred in AP_WITHHOLDING_PKG.AP_Undo_Withholding with parameters
(Parent Id = XXX, Calling_Module = CANCEL INVOICE, Awt_Date = XXX, New_Invoice_Payment_Id = , dist_Line_No = , New_Invoice_Id= , New_dist_Line_No = )
while performing the following operation: CLOSE CURSOR c_awt_dists

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Invoices -> Entry -> Invoices:
Enter an Standard Invoice
Validated
Accounted
there are not Holds = 0
Invoice is No Paid

2. Invoice Actions -> Cancel Invoices:

3. Get the Error

BUSINESS IMPACT
-----------------------
Due to this issue, users cannot cancel an invoice.

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