My Oracle Support Banner

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 OCTOBER 10, 2022

Applies to:

Oracle Public Sector Financials (International) - Version and later
Oracle Payables - Version 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

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.