Users Performing FPR Receiving Experiencing Table Locks (Doc ID 2080142.1)

Last updated on JUNE 16, 2017

Applies to:

Oracle Retail Warehouse Management System - Version 14.0 and later
Information in this document applies to any platform.
Checked for relevance 16-Jun-2017

Symptoms

During Flexible Pallet Receiving (FPR) by multiple users, their sessions get blocked recursively between each other. Below SQL queries are seen blocking each other:

 

Changes

 

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