My Oracle Support Banner

Error 'Encountered an error in JAI_OPEN_TAX_DET_PKG.determine_tax. Any error exists on importing taxes for XXXXX' While Importing GST Taxes for Receivables Invoice (Doc ID 2957663.1)

Last updated on JULY 04, 2023

Applies to:

Oracle Financials for India - Version 12.1.1 and later
Information in this document applies to any platform.

Symptoms

Autoinvoice import program is failing with an error for Receivables invoice when trying to load Tax via GST Interface functionality.

Error message as per Autoinvoice log

JAI.PLSQL.JAI_TAX_PROCESSING_PKG.IMPORT_DOCUMENT_WITH_TAX Non-STANDARD/Tax: Fetch c_err_exists:Encountered an error in JAI_OPEN_TAX_DET_PKG.determine_tax. Any error exists on importing taxes for XXXX

 Error message as per FND Debug log  

JA.PLSQL.JAI_OPEN_TAX_DET_PKG.determine_tax Non-STANDARD/Tax: Fetch c_err_exists:Encountered an error in JAI_OPEN_TAX_DET_PKG.determine_tax. Any error exists on importing taxes for XXXX
JAI.PLSQL.JAI_TAX_PROCESSING_PKG.IMPORT_DOCUMENT_WITH_TAX Non-STANDARD/Tax: Fetch c_err_exists:Encountered an error in JAI_OPEN_TAX_DET_PKG.determine_tax. Any error exists on importing taxes for XXXX
JA.PLSQL.JAI_OPEN_TAX_DET_PKG.validate_interface_tax_lines JAI_OPEN_TAX_DET_PKG: validate_interface_tax_lines Invalid tax line with interface tax line id:XXXXXXPrecedence cannot depend on itself.

  The issue can be reproduced at will with the following steps:

1. Populate AR invoice interface with invoice data and JAI interface tables with relevant Tax data.
2. Run Auto-invoice import and find that invoice is not imported in Receivables.
    India Local Receivables-> Interfaces->Autoinvoice
3. Review the Auto-invoice Request log and observe 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


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