EMM: Multiple Rows Entered In PS_WM_WO_SCHED_PO When Changing Resource Type
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.
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.
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.
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.
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.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms