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