Error Opening Receipt Loaded From Advance Shipping Receipts (ASR) When Receipt Load Cascade Is Turned On (Doc ID 1510158.1)

Last updated on JANUARY 13, 2017

Applies to:

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

Symptoms

 

Error opening Receipt loaded from Advance Shipping Receipts (ASR)when Receipt Load Cascade is turned on.

Steps to reproduce the issue:

1) Load two ASR files for the same Purchase Order
2) Run PO_RECVLOAD, two receivers will be created
3) Attempt to open either of the two receivers that were created and the following error is thrown:
 
  Negative number assigned to an unsigned field:  RECV_LN_SHIP_WK.TTL_SH_QTY_PO. (2,121) RECV_HDR.RECEIVER_ID.SaveEdit  Name:ShipQtyPct  PCPC:32463 Statement:692
  Called from:RECV_HDR.BUSINESS_UNIT.RowInit  Statement:73

4) Attempt to create a new receipt for the PO and the following error is thrown:

  Negative number assigned to an unsigned field: PO_PICK_ORD_WS.QTY_PRIOR_RECEIPT. (2,121) RECV_PICK_PO_WK.DETAILS_PB.FieldChange  Name:PriorAccptQty  PCPC:1111 Statement:18
  Called from:PO_PICK_ORD_WRK.PB_FETCH_PO.FieldChange Name:GetRecptPODetails  Statement:426
  Called from:PO_PICK_ORD_WRK.PB_FETCH_PO.FieldChange  Statement:504
  The specified field is an unsigned field and a negative value is being assigned to it.

  Review the program for errors. If necessary, run a PeopleCode trace to determine the program that failed.

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