APXINWKB When Validating or Cancelling an Invoice When Use IGI Secondary Invoice Approval (SIA) get APP-SQLAP-1000: ORA-0001 : Unique Constraint (IGI.IGI_INVOICE_DISTRIBUTIONS_U2) Violated
(Doc ID 301130.1)
Last updated on MARCH 09, 2019
Applies to:Oracle Public Sector Financials (International) - Version 188.8.131.52 and later
Oracle Payables - Version 184.108.40.206 and later
Information in this document applies to any platform.
FORM:APXINWKB - Invoice Workbench
REPORT:APXAPRVL - Batch Approval
SIA - Secondary Invoice Approval
User is unable to validate or cancel an invoice.
In release 11i the error is:
APP-SQLAP-1000:ORA-00001 unique constraint (IGI.IGI_INVOICE_DISTRIBUTIONS_U1) violated ORA-06512
"APPS IGI_AP_INVOICE_DIST_T3",line 14 ORA-04088 error during execution of trigger APPS
IGI_AP_INVOICE_DIST_T3 occurred in with parameters (p_invoice_id=
In release 12 the error is:
APP-SQLAP-1000: ORA-0001 : unique constraint (IGI.IGI_INVOICE_DISTRIBUTIONS_U2) violated
ORA-06512: at "APPS.IGI_AP_INVOICE_DIST_T3", line 14
ORA-04088 : error during execution of trigger 'APPS.IGI_AP_INVOICE_DIST_T3' occurred in Insert_tax_distributions
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