Negative number assigned to an unsigned field: PO_CNTRCT_WS1.QTY_LINE_RELEASED. (2,121) (Doc ID 2204895.1)

Last updated on JUNE 24, 2024

Applies to:

Symptoms

Negative Quantity Error Message on PO

Many of our users have several PO’s that are giving an error message when trying to open a PO by using the Add/Update PO navigation. This message is generated when attempting to open a PO. Users cannot access their PO's to reduce PO Lines because of error message saying Negative Number assigned to an unassigned field.

Also, the Purchase Orders that have been attempted to open, have been created by using the copy from contract method. Users are getting an error message that states:

 Negative number assigned to an unsigned field: PO_CNTRCT_WS1.QTY_LINE_RELEASED. (2,121) FUNCLIB_PM.LOAD_CNTRCT.FieldFormula Name:Register_Cntrct_Ln PCPC:33279 Statement:570 Called from:FUNCLIB_PM.LOAD_CNTRCT.FieldFormula Name:load_contract_lines Statement:612 Called from:FUNCLIB_PM.LOAD_CNTRCT.FieldFormula Name:load_init Statement:734 Called from:PO_PNLS_WRK.SCROLL_SELECT.FieldChange Name:select_po_lines Statement:30 Called from:PO_PNLS_WRK.SCROLL_SELECT.FieldChange Name:po_line_retrieve Statement:121 Called from:PO_SCR_NAV_WRK.FORMULA.FieldFormula Name:po_req_line_select Sta

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.


 Requesting this be a high priority. Lastly, the contracts being copied over to the PO are brand new contract and is getting an error message when the user clicks on "Submit" button. The error message states "Negative number assigned to unsigned field PO_CNTRCT_WS1 QTY_LINE_RELEASED (2,121)." Unfortunately the PO’s will be inaccessible.

ERROR
-----------------------
Negative number assigned to an unsigned field: PO_CNTRCT_WS1.QTY_LINE_RELEASED. (2,121) FUNCLIB_PM.LOAD_CNTRCT.FieldFormula Name:Register_Cntrct_Ln PCPC:33279 Statement:570 Called from:FUNCLIB_PM.LOAD_CNTRCT.FieldFormula Name:load_contract_lines Statement:612 Called from:FUNCLIB_PM.LOAD_CNTRCT.FieldFormula Name:load_init Statement:734 Called from:PO_PNLS_WRK.SCROLL_SELECT.FieldChange Name:select_po_lines Statement:30 Called from:PO_PNLS_WRK.SCROLL_SELECT.FieldChange Name:po_line_retrieve Statement:121 Called from:PO_SCR_NAV_WRK.FORMULA.FieldFormula Name:po_req_line_select Sta

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.

 Requesting this be a high priority. Lastly, the contracts being copied over to the PO are brand new contract and is getting an error message when the user clicks on "Submit" button. The error message states "Negative number assigned to unsigned field PO_CNTRCT_WS1 QTY_LINE_RELEASED (2,121)." Unfortunately the PO’s will be inaccessible.

STEPS
-----------------------
1. Create an item with multiple UOMs
2. The item has three UOMs
3. Assign Item Supplier SCM0000001
4. Make Case as Default Item Supplier UOM and EA as another Item Supplier UOM
5. Create a Purchase Order contract for the Item
6. Approve the Contract
7. Create a Requisition with the Item and UOM as EA and Qty as 100
8. Save and Submit the Requisition
9. Budget check the Req and Source it to PO
10. Budget check and Dispatch the Sourced PO
11. Validate the Contract Line Release Amount and Qty
12. Create a POA to update the UOM to CA from EA and Qty from 100 as UOM
Conversion on the Item its 100/ 50 = 2
13. Review the POA and Mark it Approved
14. Run Process Change Orders
15. After the PO_AUTO_CHNG goes to Success, Verify the Contract Line Release
Qty- Released Qty on Contract Line is NEGATIVE
16. Try to Open this PO now

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.