Users Responsibilities Disappear When Closed by HR Before Terminate Assignments
Last updated on OCTOBER 04, 2016
Applies to:Oracle Application Object Library - Version: 18.104.22.168
This problem can occur on any platform.
perwfrl.odf : Modified the select clause for expiration date and where condition.
peper11t.pkb : Modified the procedure DELETE_ROW1.
perhrwfs.pkb : Modified Procedure PER_PER_WF and Function CHK_DATE_STATUS
When deactivate Employee who is user on the application and then run the 'Synchronize WF LOCAL
tables', check the User form System Administrator -> Security -> User -> Define and query
that user, you will find that all the responsibilities are now missing
Expect to find the user as end dated but the responsibilities not to be deleted
The issue can be reproduced at will with the following steps:
1. Terminate a user from HR
2. Execute the concurrent request "Synchronize WF LOCAL tables"
3. System Administrator -> Security -> User -> Define and query that user, you will find
that all the responsibilities are now missing
The issue has the following business impact:
Due to this issue, we can't keep track of responsibilities that were assigned to previous people.
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