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 MARCH 23, 2023

Applies to:

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

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