My Oracle Support Banner

GST: Error 'JAI.PLSQL.JAI_TAX_DETERMINATION_PKG.delete_tax_lines ORA-01722: invalid number' , While Validating The Supplier Invoice. (Doc ID 2884903.1)

Last updated on JULY 22, 2022

Applies to:

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

Symptoms

ACTUAL BEHAVIOR
---------------------------
Error occurs while trying to validate one invoice.

ERROR:
---------------------------
JAI.PLSQL.JAI_TAX_DETERMINATION_PKG.calculate_tax calculate_tax----Begin----()+
JAI.PLSQL.JAI_TAX_DETERMINATION_PKG.calculate_tax Count of p_tax_lines_tbl:0
JAI.PLSQL.JAI_TAX_DETERMINATION_PKG.calculate_tax Count of p_tax_lines_tbl is 0. Return from calculate_tax.
JAI.PLSQL.JAI_TAX_DETERMINATION_PKG.delete_tax_lines delete_tax_lines----begin----()+
JAI.PLSQL.JAI_TAX_DETERMINATION_PKG.delete_tax_lines Input pn_det_factor_id id: 10990
JAI.PLSQL.JAI_TAX_DETERMINATION_PKG..delete_tax_lines Loop to discard/delete tax miscellaneous lines
JAI.PLSQL.JAI_TAX_DETERMINATION_PKG.delete_tax_lines ORA-01722: invalid number
JAI.PLSQL.JAI_TAX_DETERMINATION_PKG.delete_tax_lines delete_tax_lines----End----()+

STEPS:
---------------------------
1. Populate the AP interface tables with invoice data.
2. Run Payables Open Interface to import the invoice.
3. GST taxes are not imported from interface.
4. GST tax is imported as a ITEM line in AP invoice.
5. Validate the invoice after it is imported sucessfully.

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.