My Oracle Support Banner

PO_RECVPUSH Process Receipts Process Going to no Success and Error Out "Error Position: 0 Return: 805 - ORA-00001: unique constraint (SYSADM.PS_RECV_LN_SHIP_LC) violated" (Doc ID 2542043.1)

Last updated on APRIL 15, 2021

Applies to:

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

Symptoms

PO_RECVPUSH Process Receipts Process Going to no Success and Error Out "Error Position: 0  Return: 805 - ORA-00001: unique constraint (SYSADM.PS_RECV_LN_SHIP_LC) violated".
It was using the Load Receipts (PO_RECVLOAD) to create receipts for the PO using BCT record. User preferences set up with "Flag Items for Auto Putaway" checked. But those generated receipts are not getting auto putaway upon creation. So need to schedule "Process Receipts" process in multiple schedules so that all the receipts with unmoved inventory are processed. When run the Process Receipts process by just providing the whole business unit, the process is going to No Success with the error mentioned.
It was observed that when run the process for a specific Receipt ID by providing the Receipt Number on the run control page, it is running to success.

Replication steps:
1) Create a PO with one line item i.e. Inventory Item
2) Receive the PO fully with PO_RECVLOAD process.
3) Run PO_RECVPUSH process by providing only Business Unit.
4) Process Goes to No Success with error:

 

Changes

 n/a

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