My Oracle Support Banner

GST: Autoinvoice failing when loading AR Credit memo via interface with error "Encountered an error in JAI.PLSQL.JAI_TAX_PROCESSING_PKG.IMPORT_DOCUMENT_WITH_TAX Non-STANDARD/Tax" (Doc ID 2545676.1)

Last updated on AUGUST 01, 2019

Applies to:

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

Symptoms

On : 12.2.2 version, Transactions Related

When attempting to run Autoinvoice program the following error occurs.

ERROR
-----------------------

RAXTRX: Autoinvoice Import Program

Transferring : Current system time is 20-MAY-2019 05:25:00
ERROR: from eBusiness Tax - return code = 2 Current system time is 20-MAY-2019 05:25:10
Please review the plsql debug log for additional details. Current system time is 20-MAY-2019 05:25:10
Error calling raaebt()
Error calling raapic()
Commit after cleanup - Current system time is 20-MAY-2019 05:25:10

Encountered an error in 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 from the JAI_INTERFACE_ERR_LINES table 
----------------------------------------------------------------
ERROR_TYPE          ERROR_MESSAGE
 TAX                       JAI_MUTIPLE_INVOICE_NUM
 LINE                       Any error exists on importing taxes for Line_id 

These records are inserted for the problematic record / Interface_line_id which was rejected during import.



STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Load data into AR interface and Jai interface table.  ( this is for Credit memo)
2. Run the auto invoice import .
3. Completed with error


BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot run Autoinvoice successfully

Changes

 

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
Changes
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.