Errors are Genereated When Users are Adding a New Work Order (WO), and Change the WO Amount Field on the Cost Tab to Value Less Than the Sum of the Labor Amount and Expense Amount

(Doc ID 2064091.1)

Last updated on DECEMBER 13, 2016

Applies to:

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

Symptoms

Two issues:

1)

When Rate information is not defaulted, if the user goes to the Cost tab,
selects 'Allow Expenses', enters the Expense Amount, then changes the WO
Amount to a value less than the Expense Amount the following error is thrown:

Negative number assigned to an unsigned field: SPF_WOPO_DISTRB.DISTRIB_PCT.
(2,121) SP.SPF.WorkOrderDistribution.OnExecute  Name:InsertWODistLine
PCPC:29496  Statement:438
Called from:SP.SPF.WorkOrderDistribution.OnExecute
Name:InsertWOSplitDistLines  Statement:135
Called from:SP.SPF.WorkOrderDistribution.OnExecute
Name:InsertWOPOChartFields  Statement:82
Called from:SP.SPF.WorkOrderDistribution.OnExecute  Name:InsWODistChartFields
 Statement:37
Called from:SPF_WORK_ORDER_CMP.GBL.SPF_WORDERREC.POAMOUNT.FieldChange
Statement:7

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.

 

2)

When Rate and Expense information is defaulted, if the user goes to the Cost
tab, then changes the WO Amount to a value less than the sum of the Labor
Amount and the Expense Amount, the following error is thrown:

Assignment of "nnnnn.nnnn" to SPF_WOPO_DISTRB.DISTRIB_PCT failed. (2,119)
SP.SPF.WorkOrderDistribution.OnExecute  Name:InsertWODistLine  PCPC:29496
Statement:438
Called from:SP.SPF.WorkOrderDistribution.OnExecute
Name:InsertWOSplitDistLines  Statement:122
Called from:SP.SPF.WorkOrderDistribution.OnExecute
Name:InsertWOPOChartFields  Statement:82
Called from:SP.SPF.WorkOrderDistribution.OnExecute  Name:InsWODistChartFields
 Statement:37
Called from:SPF_WORK_ORDER_CMP.GBL.SPF_WORDERREC.POAMOUNT.FieldChange
Statement:7

The assignment to the specified field failed.

The failure can be caused by any one of several problems. The new value could
be too long to fit into the field, the new value could have too many digits
(possibly including a sign) to the left of the decimal point to fit into the
numeric field, there could be problems converting the new value to internal
format, the field might not be present in the page buffers (rare), or there
could be a memory allocation error (very rare).

Review the program for errors.  If necessary, run a PeopleCode trace to
determine the program that failed. A trace including "Show Assignments to
Variables" will trace the new value.

 


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

Issue 1:

1. Create a new work order that does not have Labor and Expense Rate defaults
2. Go to the Cost tab
3. Enter WO Amount less than Expense Amount and error 'Negative number assigned to unsigned field: SPF_WOPO_DISTRB.DISTRIB_PCT. (2,121)' is thrown
(Click for detailed replication steps for issue 1)

Issue 2:

1. Create a new work order that has Labor and Expense Rate defaults
2. Go to the Cost tab
3. Change the WO Amount to a value less than the sum of the Labor Amount and the Expense Amount and error 'Assignment of 'nnnnnn.nnnn' to SPF_WOPO_DISTRB.DISTRIB_PCT failed. (2,119).' is thrown
(Click for detailed replication steps for issue 2)

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