My Oracle Support Banner

SALESPROCESS Batch Fails with ORA-00060 Deadlock Error (Doc ID 2664083.1)

Last updated on MAY 15, 2020

Applies to:

Oracle Retail Merchandising Foundation Cloud Service - Version NA and later
Information in this document applies to any platform.

Symptoms

SALESPROCESS Batch fails with deadlock error below:

Steps to reproduce:
-------------------
1. Upload sales records with transactions for new item locations.
2. Using a wrapper script call NIL for one item/loc from step 1 and do not commit nor rollback.
3. Call salesprocess.ksh, check the job_audit_logs table notice the job is waiting after call process NIL.
4. Rerun step 2 for different items/loc. Notice salesprocess.ksh will abort with deadlock error.

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
References


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