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 SEPTEMBER 14, 2016

Applies to:

Oracle Public Sector Financials (International) - Version 11.5.10.2 and later
Oracle Payables - Version 11.5.10.2 and later
Information in this document applies to any platform.
FORM:APXINWKB - Invoice Workbench
REPORT:APXAPRVL - Batch Approval
SIA - Secondary Invoice Approval

Symptoms

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

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