there are no active responsibilities available for this user oracle apps r12

There are no Active Responsibilities available for this User


Solution:-

1. Login with sysadmin.

2. Query up the user (that is having the issue) and ensure responsibilities not showing up are NOT end dated. 

3. END DATE the USER (not the responsibility) and save the record. 

4. UN-END DATE the USER and save the record.

5 Request Name = Workflow Directory Services User/Role Validation
Batch Size = 10000
User name = SJHA
Fix dangling users = Yes
Add missing user/role assignments = Yes
Update WHO columns in WF tables = YES
Click "OK" and "Submit".

6. Clear the Cache

7. Missing responsibilities now appear.

Issue resolved.


No comments:

Size of schema in Oracle database 23AI

  How to find the size of schema in the 23AI ORACLE Database. SQL>  select sum(bytes)/1024/1024 "SIZE_IN_MB" from dba_segments;...