My Oracle Support Banner

R12: AP: Intercompany Payables Invoices Error During Validation Process in Log File - ORA-00001: Unique Constraint (ZX.ZX_DETAIL_TAX_LINES_GT_U1) Violated (Doc ID 3010736.1)

Last updated on MARCH 15, 2024

Applies to:

Oracle E-Business Tax - Version 12.1.3 and later
Oracle Payables - Version 12.1.3 and later
Information in this document applies to any platform.

Symptoms

User creates intercompany transaction between two operating units.

The Receivables Operating Unit is using a Migrated Tax Regime to Rate from 11i. The Payables Operating Unit is using a user created Tax Regime to Rate and it calls third party tax engine Vertex.

The Intercompany invoices created in Payables are facing error during validation process. 

Below error is noted in Log file

Exception while Populate zx_detail_tax_lines_gt: ORA-00001: unique constraint (ZX.ZX_DETAIL_TAX_LINES_GT_U1) violated

STEPS TO REPLICATE
-----------------------

1. Payables Responsibility > Other > Requests > Run
2. Run Invoice Validation process for Intercompany Invoice
3. The program ends in error and error is noted in log file

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


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