Wednesday, 3 December 2014

11i RESPONSIBILITY NOT VISIBLE TO THE USER IN THE LIST OF RESPONSIBILITIES ASSIGNED TO THE USER

Issue: User not able to view responsibility under following scenarios:- 

User end date has been removed.

Newly added responsibility to existing user is not visible.

---Cause:
Oracle not says so but its bug on top of RUP6 and also not resolved by RUP7.

---Resolution:
Its really hit and try kind of approach, sometime one works other time don't.
Ideally approach Option (2) should work all the time but start testing your luck with Option (1) as its easiest.

Option (1)

After adding responsibility wait for couple of seconds and then end date that resp. save , then again wait for couple of seconds and remove end date, save. Ask user to login and try. if not then bounce Apache with clear cache and ask user to try.
In case of removing end date do above for all the resp, bounce  Apache with clear cache and try.


Option (2) 

Check if the responsibility is not end dated.
Run the request " Syn responsibility role data into the WF table".
Run the request " Synchronize WF LOCAL tables"
enter the parameters-
- Orig System: ALL
- Parallel Process:0
- Logging Mode: LOGGING (Logging Activated)
- Temporary Tablespace : Blank
- Riase Errors: Yes

Run the request "Workflow Directory Services User/Role Validation" enter the parameters
- p_BatchSize:10000
- Fix dangling user/roles : Yes
- Add missing user/role assignments : Yes
- Update WHO columns in WF tables: Yes

Log off and login back and verify that the responsibility appears.

If not then bounce Apache with clear cache option.

No comments: