Receipt Close (PO_RECV_COM) abends when one receipt line is closed and other receipt line has two vouchers (Doc ID 2057916.1)

Last updated on JANUARY 13, 2017

Applies to:

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

Symptoms

Receipt Close (PO_RECV_COM) abends when one receipt line is closed and other receipt line has two vouchers

1) Have a PO1 with Line 1 = Qty 7  and Line 2 = Qty 2
2) Received RCV1 with Line 1 = Qty 3 and Line 2 = Qty 2
3) Voucher VC1 with Line 1 = Qty 1 and Line 2 = Qty 2
4) Ran Matching AP_MATCH and Rct Close PO_RECV_COM.  For the RCT Line 2 was Closed.
5) Entered Voucher VC2 with Line 1 = QTY 2
6) Ran Matching AP_MATCH and Rct Close PO_RECV_COM.  Process abends with error below...

File: e:\pt85414b-retail\peopletools\src\psappeng\aedebug.hSQL error. Stmt #: 1703 Error Position: 0 Return: 805 - ORA-00001: unique constraint (EMDBO.PS_RECV_WB_LN_SHIP) violated Failed SQL stmt: INSERT INTO PS_RECV_WB_LN_SHIP (BUSINESS_UNIT, RECEIVER_ID, RECV_LN_NBR, RECV_SHIP_ SEQ_NBR, PRE_CLOSE_STATUS, OPRID_MODIFIED_BY, LAST_DTTM_UPDATE) SELECT R.BUSINESS_UNIT, R.RECEIVER_I D, R.RECV_LN_NBR, R.RECV_SHIP_SEQ_NBR, R.RECV_SHIP_STATUS, 'VP1', CAST(SYSTIMESTAMP AS TIMESTAMP) FR OM PS_RECV_LN_SHIP R WHERE R.BUSINESS_UNIT = 'US001' AND R.RECEIVER_ID = '0000000077' AND R.MOVE_STA T_AM IN ('M', 'N') AND R.MOVE_STAT_INV IN ('M', 'N') AND R.MOVE_STAT_MFG IN ('M', 'N') AND (R.RECV_L N_MATCH_OPT = 'F' OR R.MATCH_LINE_FLG = 'N')

Process 58598 ABENDED at Step PO_RECV_COM.RVCM0200.STEP010A (SQL) -- RC = 805

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms