My Oracle Support Banner

R12: E-Business Tax/Payables Data-Fixes: Cause and action to handle ZX_LINES_SUMMARY_U1 issue / ORA-00001 (Doc ID 1152123.1)

Last updated on FEBRUARY 01, 2019

Applies to:

Oracle E-Business Tax - Version 12.0.0 to 12.2.5 [Release 12.0 to 12.2]
Oracle Payables - Version 12.0.0 to 12.2.5 [Release 12.0 to 12.2]
Information in this document applies to any platform.

Symptoms

E-Business Tax (EBTax) Information Center > EBTax Integration With EBS Modules > Payables > Note 1152123.1

When validating the Payables Invoice through the invoice workbench/submitting the Invoice validation concurrent program or when modifying an invoice and recalculating tax; user gets

ERROR
A mandatory constraint to generate unique summary tax line is violated with error ORA-00001. Please contact your System Administrator.

OR

Unexpected Error occurred during Tax Calculation.
Exception: User-Defined Exception.
Please correct the problem or contact your System Administrator.


FND Debug Log shows following error:

 

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
 1. IDENTIFYING CAUSE OF ERROR USING QUERY
 2. IDENTIFING CAUSE OF ERROR FROM FND DEBUG LOG FILE (RECOMMENDED)
 IDENTIFIED DATA CORRUPTION PATTERNS
 <Internal_Only>
 *** IMPORTANT NOTE ***
 </Internal_Only>
References

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