My Oracle Support Banner

Inventory Replenishment Process Goes to No Success With Error: ORA-00001: Unique Constraint (SYSADM.PS_BU_ITEM_LOCK) Violated When Parallelized With Reserve Materials Process (Doc ID 2873092.1)

Last updated on JUNE 02, 2022

Applies to:

PeopleSoft Enterprise SCM Inventory - Version 9.2 to 9.2 [Release 9]
Information in this document applies to any platform.

Goal

Inventory Replenishment Process (IN_REPLEN_AE) goes to No Success with error "ORA-00001: Unique Constraint (SYSADM.PS_BU_ITEM_LOCK) Violated" when parallelized with Reserve Materials Process(IN_FUL_RSV). The replenishment process needs to be reviewed and redesigned to make sure both the process can run parallely without any issue.

Steps to reproduce the issue:
1. Run the Replenishment process and the Reserve Material process simultaneously.
   Navigation: Inventory -> Replenish Inventory  -> Create Replenishment Requests
   Navigation: Inventory -> Fulfill Stock Orders -> Stock Requests -> Reserve Material Proces

Solution

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
Goal
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.