ERS9.2: Garbage Data is Getting Inserted in PS_RS_MYASSGNDS_WO Table Resulting in Bad Performance of My Assignment Component
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.
No row should get added to PS_RS_MYASSGNDS_WO table.
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