Error While Updating The Modifier On The Sales Order

Last updated on APRIL 23, 2018

Applies to:

Symptoms

On : 12.1.3 version, GST Order Management

When attempting to perform Modifier update on the Sales Order,
the following error occurs.

ERROR
-----------------------
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.update_line_det_factors ORA-01403: no data found
JAI.PLSQL.JAI_TAX_DETERMINATION_PKG.update_line_det_factors update_line_det_factors----End----()+
JA.PLSQL.JAI_OM_TAX_DET_PKG.determine_factors JAI_OM_TAX_DET_PKG: determine_factors:Update line determine factors -RETURN_STATUS = U
JA.PLSQL.JAI_OM_TAX_DET_PKG.determine_factors Encountered an error in JAI_OM_TAX_DET_PKG.determine_factors.
JAI.PLSQL.JAI_TAX_PROCESSING_PKG.CALCULATE_TAX Encountered an error in JAI_OM_TAX_DET_PKG.determine_factors.
ZX.PLSQL.ZX_SRVC_TYP_PKG.CALCULATE_TAX JAI_TAX_PROCESSING_PKG.CALCULATE_TAX RETURN_STATUS = E


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Raise Sales order
2. Make a Modifier update

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot get the sales order created with modifier update

Changes

Cause