PO_RECVPUSH abended At Step PO_CLSSHORT.ONERCPT.STEP10 (SQL) -- RC = 1400

(Doc ID 2306684.1)

Last updated on SEPTEMBER 12, 2017

Applies to:

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

Symptoms

The RECV_00 process abends during the PO Close Short processing for an Amount Only Receipt.

Error from Message Log: 

File: /vob/peopletools/src/psappeng/aedebug.hSQL error. Stmt #: 1723 Error Position: 0 Return: 140 0 - ORA-01400: cannot insert NULL into ("SYSADM"."PS_PO_CLSSHT_TAO"."MERCHANDISE_AMT") Failed SQL stmt: INSERT INTO PS_PO_CLSSHT_TAO (PROCESS_INSTANCE , BUSINESS_UNIT , PO_ID , LINE_NBR , SCHED_NBR , QTY_PO , PRICE_PO , AMT_ONLY_FLG , CLS_SHORT_SET_OPT , QTY_RECEIVED , AMT_RECVD , AUTOA PPROVE_CHNG) SELECT 117893 , S.BUSINESS_UNIT , S.PO_ID , S.LINE_NBR , S.SCHED_NBR , S.QTY_PO , S.PRI CE_PO , L.AMT_ONLY_FLG , C.CLS_SHORT_SET_OPT , SUM(R.QTY_SH_NETRCV_VUOM) , SUM(R.MERCHANDISE_AMT) , MAX(BU.AUTOAPPROVE_CHNG) FROM PS_PO_HDR H , PS_PO_LINE L , PS_PO_LINE_SHIP S , PS_RECV_LN_SHIP R , P S_BUS_UNIT_TBL_PM BU , PS_PO_CLS_SHT_RULE C WHERE R.RECV_SHIP_STATUS <> 'X' AND H.BUSINESS_UNIT = R. BUSINESS_UNIT_PO AND H.PO_ID = R.PO_ID AND H.PO_STATUS NOT IN ('X','C') AND H.RECV_STATUS = 'P' AND

Process 117893 ABENDED at Step PO_CLSSHORT.ONERCPT.Step10 (SQL) -- RC = 1400


The issue can be reproduced at will with the following steps:

  1. Create an Amount Only purchase order for 1000.00
  2. On the Attributes tab: Check Amount Only.
  3. On the Receiving tab: Set Receiving to Required.
  4. Matching = Not Required.
  5. Save the PO.
  6. Update the PO and check the Close Short flag at the Receiving tab.
  7. Dispatch the PO.
  8. Receive the PO short, example for 978.00. Check the Close Short flag.
  9. Check the Run Close Short and Interface Receipts options.
  10. Save the Receipt.
  11. Process Monitor - Process goes to No Success.
  12. Message Log shows: ABENDED at Step PO_CLSSHORT.ONERCPT.Step10 (SQL) -- RC = 1400


The issue has the following business impact:
Due to this issue, users cannot run the Recv_00 along with the close short process.

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