EMM: Multiple Rows Entered In PS_WM_WO_SCHED_PO When Changing Resource Type

(Doc ID 2373311.1)

Last updated on MARCH 13, 2018

Applies to:

PeopleSoft Enterprise FIN Maintenance Management - Version 9.2 and later
Information in this document applies to any platform.

Symptoms

In Voucher Regular Entry when associating the voucher to a Work Order,  the following occurs:

1. There seems to be a difference in behavior depending on PS_WM_WO_SCHED_PO data.
If the Work Order ID has 0 rows in this table, every time you change the Resource Type and click "Save For Later", it will keep updating the same row.
If the Work Order ID has a row, every time you change the Resource Type and click "Save For Later", it will add new rows.

2. When we use Save for Later it creates records with 0 cost and they are staying in the table even when the voucher is deleted. More so, they appear on WO when the voucher is deleted.

Expected Behavior
----------------------------

The expectation is that when changing a resource type on an associated work order from a voucher using the save for later functionality, the updates to the work order id will be consistent. The customer suggests that the resource type changes should be posted to the work order only after the voucher is approved when saving the changes via the save for later functionality. Also, when deleting a voucher, it is expected that the updates to the work order from that voucher will be deleted as well.

Steps
----------
This issue can be replicated by performing the following steps:

1) Create a voucher.
2) Click on the Work Order link and enter a work order id and a resource type. Click OK. Click on the save for later button on the voucher.
3) Repeat point 2 multiple times checking the PS_WM_WO_SCHED_PO table after every update. Note that only 1 row exists and it is updated for every change entered.
4) Create a new voucher and enter resource type changes for the same work order id as in points 1 & 2 above.
5) Repeat point 4 multiple times checking the PS_WM_WO_SCHED_PO table after every update. Note that a new row is inserted for every change entered.
6) Delete the voucher in point 4 above. Check the resource type changes posted to the work order for the deleted voucher. Note that they are still posted to the work order. They were not deleted when the voucher was deleted.

Business Impact
--------------------------
The changes made to resource type on a voucher are not posted to a work order in a consistent manner. Therefore, it is difficult to track the changes. When a voucher is deleted the changes posted to a work order for the deleted voucher are not deleted from the work order. This contributes to a lack of ability to accurately track changes.

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