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.

Symptoms

 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.

Steps:
---------
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.

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