GST - Not Able To Validate Invoice Which Matched With Receipt Of Pre-GST Taxes (Doc ID 2359876.1)

Last updated on JULY 02, 2023

Applies to:

Symptoms

PROBLEM STATEMENT
=================
Unable to validate invoices do to the following error message:

JAI.PLSQL.JAI_TAX_DETERMINATION_PKG.check_required_params
check_required_params----Begin----()+
JAI.PLSQL.JAI_TAX_DETERMINATION_PKG.check_required_params
check_required_params trx_date is required
JAI.PLSQL.JAI_TAX_DETERMINATION_PKG.check_required_params return
pv_return_status is:U
JAI.PLSQL.JAI_TAX_DETERMINATION_PKG.check_required_params
check_required_params----End----()+
JAI.PLSQL.JAI_TAX_DETERMINATION_PKG.VALIDATE_INIT_DET_FACTORS calling
get_tax_determination_basis with error:
JAI.PLSQL.JAI_TAX_DETERMINATION_PKG.insert_line_det_factors
validate_init_det_factors returned errors
JAI.PLSQL.JAI_TAX_DETERMINATION_PKG.insert_line_det_factors
insert_line_det_factors
JAI.PLSQL.JAI_TAX_DETERMINATION_PKG.insert_line_det_factors
insert_line_det_factors----End----()+
JAI.PLSQL.JAI_AP_TAX_PROCESS_PKG.prepare_det_factor JAI_AP_TAX_PROCESS_PKG:
prepare_det_factor:Insert tax determination factors -RETURN_STATUS = U
JAI.PLSQL.JAI_AP_TAX_PROCESS_PKG..prepare_det_factor. Error U:
JAI.PLSQL.JAI_AP_TAX_PROCESS_PKG..Populate_Stnd_Inv_Taxes_Pvt.
Other_Exception 1:User-Defined Exception
JAI.PLSQL.JAI_AP_STND_TAX_PROCESS.Populate_Stnd_Inv_Taxes_Pvt User-Defined
Exception
fnd.plsql.APP_EXCEPTION.RAISE_EXCEPTION.dict_auto_log APP-JA-460204:
Encountered the error in JAI_AP_TAX_PROCESS_PKG.Populate_Stnd_Inv_Taxes_Pvt:
User-Defined Exception
JAI.PLSQL.JAI_AP_TAX_PROCESS_PKG..Populate_Stnd_Inv_Taxes. Other_Exception
-20001:ORA-20001: APP-JA-460204: Encountered the error in
JAI_AP_TAX_PROCESS_PKG.Populate_Stnd_Inv_Taxes_Pvt: User-Defined Exception
JAI.PLSQL.JAI_AP_STND_TAX_PROCESS.Populate_Stnd_Inv_Taxes ORA-20001:
APP-JA-460204: Encountered the error in
JAI_AP_TAX_PROCESS_PKG.Populate_Stnd_Inv_Taxes_Pvt: User-Defined Exception
fnd.plsql.APP_EXCEPTION.RAISE_EXCEPTION.dict_auto_log APP-JA-460204:
Encountered the error in JAI_AP_TAX_PROCESS_PKG.Populate_Stnd_Inv_Taxes:
ORA-20001: APP-JA-460204: Encountered the error in
JAI_AP_TAX_PROCESS_PKG.Populate_Stnd_Inv_Taxes_Pvt: User-Defined Exception
jai.plsql.JAI_AP_STND_TAX_PROCESS.Populate_Stnd_Inv_Taxes. Other_Exception
-20001:ORA-20001: APP-JA-460204: Encountered the error in
JAI_AP_TAX_PROCESS_PKG.Populate_Stnd_Inv_Taxes: ORA-20001: APP-JA-460204:
Encountered the error in JAI_AP_TAX_PROCESS_PKG.Populate_Stnd_Inv_Taxes_Pvt:
User-Defined Exception
JAI.PLSQL.JAI_AP_STND_TAX_PROCESS.Populate_Stnd_Inv_Taxes ORA-20001:
APP-JA-460204: Encountered the error in
JAI_AP_TAX_PROCESS_PKG.Populate_Stnd_Inv_Taxes: ORA-20001: APP-JA-460204:
Encountered the error in JAI_AP_TAX_PROCESS_PKG.Populate_Stnd_Inv_Taxes_Pvt:
User-Defined Exception
fnd.plsql.APP_EXCEPTION.RAISE_EXCEPTION.dict_auto_log APP-JA-460204:
Encountered the error in JAI_AP_STND_TAX_PROCESS.Populate_Stnd_Inv_Taxes:
ORA-20001: APP-JA-460204: Encountered the error in
JAI_AP_TAX_PROCESS_PKG.Populate_Stnd_Inv_Taxes: ORA-20001: APP-JA-460204:
Encountered the error in JAI_AP_TAX_PROCESS_PKG.Populate_Stnd_Inv_Taxes_Pvt:
User-Defined Exception

Cause

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