Receiving Transactions Fail with TM_TIMEOUT or Deadlock (Doc ID 1071727.1)

Last updated on DECEMBER 09, 2014

Applies to:

Oracle Inventory Management - Version: 11.5.10.0 to 11.5.10 - Release: 11.5.10 to 11.5
Information in this document applies to any platform.
Form:RCVRCERC.FMB - Enter Receipts GUI

Symptoms

When attempting to receive all types of transactions the following error is received:

APP-FND-00204: Concurrent Manager encountered an error while running the spawned concurrent program Receiving Transaction Manager - RCVOLTM for your concurrent request 842630.
TM-TIMEOUT.

Steps to Reproduce:
1. Purchasing Responsibility
2. Receiving -> Receipts
3. Enter transaction number and click find
4. TM-TIMEOUT error

If using mobile the webpage shows:
Internet Explorer cannot display the webpage
Most likely causes:
- You are not connected to the Internet.
- The website is encountering problems.
- There might be a typing error in the address.

Trace file shows there is a deadlock.

PARSING IN CURSOR #95 len=119 dep=0 uid=44 oct=3 lid=44 tim=4580170849
hv=2334877912 ad='f5d532a8'
select line_location_id into :b0 from po_line_locations_all
where line_location_id=:b1 for update of line_location_id
END OF STMT
PARSE #95:c=0,e=67,p=0,cr=0,cu=0,mis=0,r=0,dep=0,og=4,tim=4580170846
BINDS #95:
kkscoacd
Bind#0
oacdty=02 mxl=22(22) mxlc=00 mal=00 scl=00 pre=00
oacflg=00 fl2=1000000 frm=00 csi=00 siz=24 off=0
kxsbbbfp=beb4e948 bln=22 avl=04 flg=05
value=627460
WAIT #95: nam='enq: TX - row lock contention' ela= 2996708
name|mode=1415053318 usn<<16 | slot=589860 sequence=1980889 obj#=961051
tim=4583168028
-------------------------
PARSING IN CURSOR #95 len=119 dep=0 uid=44 oct=3 lid=44 tim=4580170849
hv=2334877912 ad='f5d532a8'
select line_location_id into :b0 from po_line_locations_all
where line_location_id=:b1 for update of line_location_id
END OF STMT
PARSE #95:c=0,e=67,p=0,cr=0,cu=0,mis=0,r=0,dep=0,og=4,tim=4580170846
BINDS #95:
kkscoacd
Bind#0
oacdty=02 mxl=22(22) mxlc=00 mal=00 scl=00 pre=00
oacflg=00 fl2=1000000 frm=00 csi=00 siz=24 off=0
kxsbbbfp=beb4e948 bln=22 avl=04 flg=05
value=627460
WAIT #95: nam='enq: TX - row lock contention' ela= 2996708
name|mode=1415053318 usn<<16 | slot=589860 sequence=1980889 obj#=961051
tim=4583168028

To create database level trace follow <> To Create Forms And Database Level Trace For Receiving Transactions:

Changes

Applied Procurement Rollup 12 <>.

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