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 JULY 16, 2024
Applies to:
Oracle E-Business Tax - Version 12.0.0 to 12.2.5 [Release 12.0 to 12.2]Oracle Payables - Version 12.2.9 to 12.2.9 [Release 12.2]
Oracle Payables - Version 12.2.11 to 12.2.11 [Release 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
Error
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 |