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 NOVEMBER 13, 2019

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"

Replication Steps:

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

File: /vob/peopletools/src/psappeng/aedebug.hSQL error. Stmt #: 1725 Error Position: 0 Return: 805 - ORA-00001: unique constraint (SYSADM.PS_RECV_LN_SHIP_LC) violated
Failed SQL stmt: INSERT INTO PS_RECV_LN_SHIP_LC(BUSINESS_UNIT , BUSINESS_UNIT_PO , COST_ELEMENT , CURRENCY_CD , LC_ACCRUAL_FLAG , LC_COMP_FLAG , LC_COMP_ON_PO , LC_RTV_CREDIT , LINE_NBR , MATCH_STATUS_LC , MISC_CHARGE_CODE , MISC_CHG_AMT , PO_ID , PPV_POST_FLG , PROCESS_FLAG , PROCESS_INSTANCE , RECEIVER_ID , RECV_LN_NBR , RECV_SHIP_SEQ_NBR , SCHED_NBR , UNIT_PRICE_LC) SELECT BUSINESS_UNIT , BUSINESS_UNIT_PO , COST_ELEMENT , CURRENCY_CD , LC_ACCRUAL_FLAG , LC_COMP_FLAG , LC_COMP_ON_PO , LC_RTV_CREDIT , LINE_NBR , MATCH_STATUS_LC , MISC_CHARGE_CODE , MISC_CHG_AMT , PO_ID , PPV_POST_FLG , PROCESS_FLAG , 0 , RECEIVER_ID , RECV_LN_NBR , RECV_SHIP_SEQ_NBR , SCHED_NBR , UNIT_PRICE_LC FROM PS_RECV_SHP_LC_T4 WHERE PROCESS_INSTANCE = 999



1. It was using the Load Receipts (PO_RECVLOAD) to create receipts for the PO using BCT record. 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.
But, when run the Process Receipts process by just providing the Business Unit, the process is going to No Success with the error mentioned.

2.Already have  user preferences set up with "Flag Items for Auto Putaway" checked. Still when run the process is going to No Success. 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.
But there is the same operation for the whole business unit the process is running into No Success.



ERROR
-----------------------
File: /vob/peopletools/src/psappeng/aedebug.hSQL error. Stmt #: 1725 Error Position: 0 Return: 805 - ORA-00001: unique constraint (SYSADM.PS_RECV_LN_SHIP_LC) violated
Failed SQL stmt: INSERT INTO PS_RECV_LN_SHIP_LC(BUSINESS_UNIT , BUSINESS_UNIT_PO , COST_ELEMENT , CURRENCY_CD , LC_ACCRUAL_FLAG , LC_COMP_FLAG , LC_COMP_ON_PO , LC_RTV_CREDIT , LINE_NBR , MATCH_STATUS_LC , MISC_CHARGE_CODE , MISC_CHG_AMT , PO_ID , PPV_POST_FLG , PROCESS_FLAG , PROCESS_INSTANCE , RECEIVER_ID , RECV_LN_NBR , RECV_SHIP_SEQ_NBR , SCHED_NBR , UNIT_PRICE_LC) SELECT BUSINESS_UNIT , BUSINESS_UNIT_PO , COST_ELEMENT , CURRENCY_CD , LC_ACCRUAL_FLAG , LC_COMP_FLAG , LC_COMP_ON_PO , LC_RTV_CREDIT , LINE_NBR , MATCH_STATUS_LC , MISC_CHARGE_CODE , MISC_CHG_AMT , PO_ID , PPV_POST_FLG , PROCESS_FLAG , 0 , RECEIVER_ID , RECV_LN_NBR , RECV_SHIP_SEQ_NBR , SCHED_NBR , UNIT_PRICE_LC FROM PS_RECV_SHP_LC_T4 WHERE PROCESS_INSTANCE = 2023014




STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1) Create a PO with one line item i.e. Inventory Item
2) Receive the PO fully.
3) Run PO_RECVPUSH process by providing only Business Unit.
4) Process Goes to No Success with error



Changes

 

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.