Unable To Approve The Purchase Orders Getting Error "ORA-01403: no data found" (Doc ID 1999866.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 version, India PO Localizations


Unable to approve the Purchase Orders

ERROR
-----------------------

Error Messages: Unexpected Error Occured During Tax Calculation.

On Generating FND Debug Messages the following error 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.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