Unable to Approve PO Error "Unexpected error occurred during Tax Calculation" & "JAI_PROCESS_MSG=jai_po_tax_pkg.calculate_tax.Err:ORA-01403: no data found" (Doc ID 2070881.1)

Last updated on MARCH 08, 2017

Applies to:

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

Symptoms

On 12.1.3,

Unable to approve the Purchase Orders

ERROR
--------

In PO form "Error Message:Unexpected error occurred during Tax Calculation"

On Generating the FND Debug Log Messages the following is exact error:
fnd.plsql.APP_EXCEPTION.RAISE_EXCEPTION.dict_auto_log JAI_EXCEPTION_OCCURED
(JAI_PROCESS_MSG=jai_po_tax_pkg.calculate_tax.Err:ORA-01403: no data found)
JAI.PLSQL.jai_po_proc_pkg.copy_quot_taxes ORA-20001: JAI_EXCEPTION_OCCURED
(JAI_PROCESS_MSG=jai_po_tax_pkg.calculate_tax.Err:ORA-01403: no data found)
fnd.plsql.APP_EXCEPTION.RAISE_EXCEPTION.dict_auto_log JAI_EXCEPTION_OCCURED
(JAI_PROCESS_MSG=jai_po_tax_pkg.calculate_tax.Err:ORA-01403: no data found)
JAI.PLSQL.jai_po_proc_pkg.process_po_shipment_line ORA-20001:
JAI_EXCEPTION_OCCURED
(JAI_PROCESS_MSG=jai_po_tax_pkg.calculate_tax.Err:ORA-01403: no data found)
fnd.plsql.APP_EXCEPTION.RAISE_EXCEPTION.dict_auto_log JAI_EXCEPTION_OCCURED
(JAI_PROCESS_MSG=jai_po_tax_pkg.calculate_tax.Err:ORA-01403: no data found)
JAI.PLSQL.jai_po_proc_pkg.process_po_line ORA-20001: JAI_EXCEPTION_OCCURED
(JAI_PROCESS_MSG=jai_po_tax_pkg.calculate_tax.Err:ORA-01403: no data found)
fnd.plsql.APP_EXCEPTION.RAISE_EXCEPTION.dict_auto_log JAI_EXCEPTION_OCCURED
(JAI_PROCESS_MSG=jai_po_tax_pkg.calculate_tax.Err:ORA-01403: no data found)
JAI.PLSQL.jai_po_proc_pkg.process_po ORA-20001: JAI_EXCEPTION_OCCURED
(JAI_PROCESS_MSG=jai_po_tax_pkg.calculate_tax.Err:ORA-01403: no data found)
fnd.plsql.APP_EXCEPTION.RAISE_EXCEPTION.dict_auto_log JAI_EXCEPTION_OCCURED
(JAI_PROCESS_MSG=jai_po_tax_pkg.calculate_tax.Err:ORA-01403: no data found)
JAI.PLSQL.JAI_TAX_PROCESSING_PKG.CALCULATE_TAX ORA-20001:
JAI_EXCEPTION_OCCURED
(JAI_PROCESS_MSG=jai_po_tax_pkg.calculate_tax.Err:ORA-01403: no data found)

Steps to Reproduce
------------------------
1. Create a Requisition
2. Autocreate to create a PO
3. Try approving PO

Business Impact
------------------------
Due to this issue users are unable to approve PO and create Inventory receipt
to receive material

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms