Incorrect Validation For POs Created Form Work Orders (Doc ID 2120627.1)

Last updated on MARCH 25, 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

When we try to dispatch POs created from work orders, we get the following message even though the PO is not edited by us :
"Price on line %1, schedule %2 does not balance to sum of value adjustments for the schedule."

PO_VAL_ADJ_P gets its data form REQ_VAL_ADJ_P, which is a schedule level table and not distribution table,  Note that each distribution in req schedule (i.e LBR and EXP) are mapped to individual PO lines,  When the validation runs (BU setup for the PO BU should throw Warning against price adjustments), it compares schedule level data (PO_VAL_ADJ_P table ) to data acquired from distributions (currently at PO_LINE_SHIP, originally from req distributions). SO it's always going to fail.

"Price on line %1, schedule %2 does not balance to sum of value adjustments for the schedule."

Steps to reproduce the issue:
1. Create a req in sPro with at least one labor and one expense distribution for a line.
2. Create a WO with the req line.
3. Stage the lines for creating PO ('Process PO' from work order page. This requires PO integration on in Service Procurement Installation options).
4. Run PO Calc and PO Create processes to create a PO form that WO.
5. Check that ADJ_AMT of PO_VAL_ADJ_P for each PO line and schedule is the sum of labor and expense amount.
6. Try to open the PO and dispatch the PO and it will throw the warning :"Price on line %1, schedule %2 does not balance to sum of value adjustments for the schedule."


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