11i:AP:Failed To Cancel AP Invoice Error 'APP-SQLAP-10000 ORA-01407'
(Doc ID 3001828.1)
Last updated on FEBRUARY 01, 2024
Applies to:
Oracle Payables - Version 11.5.10.2 to 11.5.10.2 [Release 11.5]Information in this document applies to any platform.
Symptoms
On 11.5.10.2 in Production:
When attempting to cancel an invoice or manually release a hold, the following error occurs:
APP-SQLAP-10000 ORA-01407 cannot update
PO.PO_DISTRIBUTIONS_ALL.LAST_UPDATE_DATE to NULL occured in AP_CANCEL_PKG.AP_CANCEL_SINGLE_INVOICE
=11838248 P_set_of_books_id=1 P_accounting_date=16-oct-07 P_period_name=OCT-07-FY-08)
While performing the following operations:
Adjust quantity_billed and amount_billed in po_distributions
PO.PO_DISTRIBUTIONS_ALL.LAST_UPDATE_DATE to NULL occured in AP_CANCEL_PKG.AP_CANCEL_SINGLE_INVOICE
=11838248 P_set_of_books_id=1 P_accounting_date=16-oct-07 P_period_name=OCT-07-FY-08)
While performing the following operations:
Adjust quantity_billed and amount_billed in po_distributions
Steps to Reproduce:
1)Query the invoice in Invoice Workbench
2)Invoices>>Find Invoice
3)Try to cancel the invoice, get error
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 |
Cause |
Solution |
References |