During Login Responsibilities Assigned to Users do not Appear in the Navigator Page

Why is assigned responsibility not appearing in the navigator page during login?

User data in the FND_USER, FND_RESPONSIBILITY, WF_LOCAL_USER_ROLES, and WF_USER_ROLE_ASSIGNMENTS tables is not valid.  To synchronize data follow the steps below:

1.  Navigate to the define user form (FNDSCAUS).
2.  Query up the user (that is having the issue) and insure the responsibility is NOT end dated.
3.  END DATE the USER (not the responsibility) and save the record.
4.  UNEND DATE the USER and save the record.
5.  Run the request ‘Sync responsibility role data into the WF table’.
6.  Run the request “Synchronize WF LOCAL tables”.
7.  Run the request “Workflow Directory Services User/Role Validation” (with parameters 10000, yes, yes, yes).
8.  Have the user log off and back on and verify that the responsibility appears.


How to force all Applications users to change their password at the next login?

“Expire all FND_USER passwords”

This is available starting in RUP4. Requires Patch 4676589 ATG RUP 4.

The script to expire all passwords in the fnd_user table is $FND_TOP/patch/115/sql/AFCPEXPIRE.sql.  It can be executed from SQL*Plus or as a Concurrent Program:

sqlplus -s APPS/<pwd> @AFCPEXPIRE.sql
Submit concurrent request: CP SQL*Plus Expire FND_USER Passwords

This script sets the fnd_user.password_date to null for all users which causes all user passwords to expire. It can also be run as a SQL*Plus concurrent program. The user will need to create a new password upon the next login.