My Oracle Support Banner

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

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