My Oracle Support Banner

Processing Item and PO Upload In Parallel Cause Deadlocks (Doc ID 2427451.1)

Last updated on JULY 25, 2018

Applies to:

Oracle Retail Merchandising System - Version 16.0.1 and later
Information in this document applies to any platform.


Actual Behavior

After you start processing a Purchase Order (PO) Upload, you see the deadlocks for an existing Item Upload which eventually causes the PO Upload to perform slow.

Expected Behavior
 Though Item and PO Upload belong to different AQ, these two AQs feed into one DB Scheduler. Hence, expect the application to provide a way where the user can define or feed in the scheduler to reduce the contention.

What is Working
There are no issues when only Item Induction.

Steps to Reproduce
The issue can be reproduced at will with the following steps:
1. Start Item Upload and PO Upload in parallel.
2. Notice the deadlocks.




To view full details, sign in with your My Oracle Support account.

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

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.