My Oracle Support Banner

Warehouse Available Inventory Import Fails With "ORA-00060: deadlock detected while waiting for resource" When Processing Files Having Same Combination Warehouse_id / item_id (Doc ID 2955407.1)

Last updated on JUNE 15, 2023

Applies to:

Oracle Retail Enterprise Inventory Cloud Service - Version 23.1 and later
Information in this document applies to any platform.

Symptoms

The batch Warehouse Available Inventory Import is failing the job execution when it is processing more than 1 file where those files have the same combination of warehouse_id / item_id.

ERROR
-----------------------
oracle.retail.sim.common.core.SimServerException: Error executing stored procedure. SQLException(60): ORA-00060: deadlock detected while waiting for resource
ORA-06512: at "SIM01.WAREHOUSE_PKG", line 107
ORA-06512: at "SIM01.WAREHOUSE_PKG", line 33
ORA-06512: at line 1

Steps to reproduce:

Prerequisites: have files containing the same combination of warehouse_id / item_id.

1. Upload into FTS Imports Object Storage 2 ZIP files where each zip holds 1 file.
2. Start Job "Warehouse Available Inventory File Import".

Cause

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
Symptoms
Cause
Solution


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