Error is Received when Saving an Amount Only Purchase Order. Error: "Negative number assigned to an unsigned field: RECV_LN_DISTRIB.QTY_DS_ACCPT_SUOM. (2,121) RECV_LN_DISTRIB.MERCHANDISE_AMT.FieldChange " (Doc ID 2165185.1)

Last updated on OCTOBER 17, 2016

Applies to:

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

Symptoms

When creating a receipt for an Amount Only PO, the following error is received.  This is happening when the Receipt Amount is redistributed on the Receipt Distribution page.

ERROR:  

Negative number assigned to an unsigned field:
RECV_LN_DISTRIB.QTY_DS_ACCPT_SUOM. (2,121)
RECV_LN_DISTRIB.MERCHANDISE_AMT.FieldChange PCPC:1039 Statement:24

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.


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

1) Create a PO with one PO line and 13 distribution lines - PO Amount: 250000
2) Approve, Budget Check and Dispatch.
3) Create a Receipt.
4) Enter merchandise amounts - redistributing the distribution values.
5) Save the receipt. Error is encountered. "Negative number assigned to an unsigned field"



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