R12: EBTax: Error APP-SQLAP-10000 ORA-01403 While Trying To Cancel Invoice
(Doc ID 1640983.1)
Last updated on MARCH 26, 2019
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.
When attempting to cancel an invoice, the following error occurs.
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
This issue can be reproduced at will with the following steps:
1. Invoices -> Entry -> Invoices:
Enter an Standard Invoice
there are not Holds = 0
Invoice is No Paid
2. Invoice Actions -> Cancel Invoices:
3. Get the Error
Due to this issue, users cannot cancel an invoice.
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