R12: AP: Unable to Cancel an Invoice APP-SQLAP-10000: ORA-00001: Unique Constraint (AP.AP_INVOICE_DISTRIBUTIONS_U1) Violated Occurred in AP_INVOICE_LINES_PKG
(Doc ID 2988756.1)
Last updated on JUNE 13, 2024
Applies to:
Oracle Payables - Version 12.0.0 and laterInformation in this document applies to any platform.
Symptoms
While trying to cancel an invoice, below error occurred:
APP-SQLAP-10000: ORA-00001: unique constraint (AP.AP_INVOICE_DISTRIBUTIONS_U1) violated occurred in
AP_INVOICE_LINES_PKG.Discard_Inv_Line <-AP_CANCEL_PKG.AP_CANCEL_SINGLE_INVOICE<-APXINWKB
with parameters ( P_invoice_id = XXXXXXX P_line_number = 1 P_last_updated_by = XXXXXX P_last_update_login = XXXXXX P_calling_mode = CANCEL)
while performing the following operation:
Insert distribution reversals for existing lines
AP_INVOICE_LINES_PKG.Discard_Inv_Line <-AP_CANCEL_PKG.AP_CANCEL_SINGLE_INVOICE<-APXINWKB
with parameters ( P_invoice_id = XXXXXXX P_line_number = 1 P_last_updated_by = XXXXXX P_last_update_login = XXXXXX P_calling_mode = CANCEL)
while performing the following operation:
Insert distribution reversals for existing lines
Steps to reproduce:
1. Query an invoice.
2. Click the Actions button.
3. Select the 'Cancel' option and click OK.
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 |