ERS9.2: Garbage Data is Getting Inserted in PS_RS_MYASSGNDS_WO Table Resulting in Bad Performance of My Assignment Component

(Doc ID 2411162.1)

Last updated on JUNE 15, 2018

Applies to:

PeopleSoft Enterprise FIN Resource Management - Version 9.2 to 9.2 [Release 9]
Information in this document applies to any platform.


 Garbage added in PS_RS_MYASSGNDS_WO when approver marks worklist as worked from My Assignment component. This results in bad performance when the user accesses the component.

1) Enable approval for Assignment.
2) Create an Assignment.
3) Cancel the assignment.
4) Approver marks the Worklist Complete.

Expected result:
No row should get added to PS_RS_MYASSGNDS_WO table.

Actual result:
Garbage row in PS_RS_MYASSGNDS_WO is added.

Please see replication steps document for more details.




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