R12: AP: EBTax : Payable Invoices Have Error on Tax Calculation - "ZX_TDS_CALC_SERVICES_PUB_PKG.dump_detail_tax_lines_into_gt ORA-00001 error occurred for Trx_id : -99"
(Doc ID 2884186.1)
Last updated on JULY 19, 2022
Applies to:Oracle Payables - Version 12.1.1 and later
Oracle E-Business Tax - Version 12.1.1 and later
Information in this document applies to any platform.
Users upgraded from Oracle application from 12.1.3 to 12.2.11 and getting tax calculation error for all invoices in Payables
Unexpected error occurred during tax calculation
Error from Debug log
ZX.PLSQL.ZX_TDS_CALC_SERVICES_PUB_PKG.dump_detail_tax_lines_into_gt Insert detail tax lines in ZX_DETAIL_TAX_LINES_GT
ZX.PLSQL.ZX_TDS_CALC_SERVICES_PUB_PKG.dump_detail_tax_lines_into_gt 3 Error(s) occured while inserting tax lines in ZX_DETAIL_TAX_LINES_GT.
ZX.PLSQL.ZX_TDS_CALC_SERVICES_PUB_PKG.dump_detail_tax_lines_into_gt ORA-00001 error occurred for Trx_id : -99
The issue can be reproduced at will with the following steps:
1. Payables Responsibility > Invoices > Invoices
2. Create invoice and validate or click on Calculate tax -- Error received
3. Go to Tax Details form > Tax LOV > Shows Duplicate values for same tax
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