R12: Master Note: Invoice Validation Program Finishes In Error Status. REP-1419: ORA-00001: unique constraint violated (Doc ID 1307197.1)

Last updated on SEPTEMBER 06, 2016

Applies to:

Oracle Payables - Version 12.0.1 to 12.1.3 [Release 12.0 to 12.1]
Information in this document applies to any platform.
Invoice Validation program - APPRVL
Invoices Entry form - APXINWKB


Symptoms

Trying to validate invoices the following error messages can arise:

 1) If the validation is performed using the On-Line validation:
         Invoice is not validated. No error message is displayed in the form.
         Reviewing the FND Debug Log file, the following error message is displayed:
               --- --- ---
               ORA-00001: unique constraint (ZX.ZX_LINES_SUMMARY_U1) violated
               --- --- ---

         Another possible error message in FND Debug Log file is:
               --- --- ---
               ORA-00001: unique constraint (ZX.ZX_DETAIL_TAX_LINES_GT_U1) violated
               --- --- ---

 2) If the validation is submitted using the Invoice Validation concurrent program, the following error message is displayed in the log file:
               --- --- ---
               REP-1419: 'beforereport': PL/SQL program aborted.
               ORA-00001: unique constraint (ZX.ZX_LINES_DET_FACTORS_U1) violated
               --- --- ---

Important Note: The objective of a Individual Error Note is to take a specific error message (usually a handled error message but can be an unhandled error in certain cases) and explain the various causes and solutions for that error.

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