25117335 Not Able To Book Sales Orders (Doc ID 2246842.1)

Last updated on MARCH 27, 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 OM Localizations

When attempting to Multi Line RMA Receiving for One Header ID,
the following error occurs.

ERROR
-----------------------
875 Exception occured in DEFAULT_TAXES_ONTO_LINE procedure sqlcode -60, sqlerrm ORA-00060: deadlock detected while waiting for resource
5858 Exception occured in DEFAULT_TAX procedure sqlcode -20001 sqlerrm ORA-20001: JAI_EXCEPTION_OCCURED (JAI_PROCESS_MSG=jai_om_rma_pkg.default_taxes_onto_line.Err:ORA-00060: deadlock detected while waiting for resource)
ORA-20001: JAI_EXCEPTION_OCCURED (JAI_PROCESS_MSG=jai_om_rma_pkg.default_taxes_onto_line.Err:ORA-00060: deadlock detected while waiting for resource)
Encountered an error in JAI_OM_TAX_PROCESSING_PKG.DEFAULT_TAX ORA-20001: JAI_EXCEPTION_OCCURED (JAI_PROCESS_MSG=jai_om_rma_pkg.default_taxes_onto_line.Err:ORA-00060: deadlock detected while waiting for resource)
JAI_TAX_PROCESSING_PKG.CALCULATE_TAX RETURN_STATUS = E
User-Defined Exception
ZX_API_PUB: CALCULATE_TAX:ZX_SRVC_TYP_PKG.calculate_tax returned errors


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
a. Populate ROI interface tables
rcv_header_interface (RHI), rcv_transactions_interface (RTI)

b. Run Receiving Transaction Processor.

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot use ROI

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