11i:- Issues after applying ATG RUP7 -- Part 3

• Issue:- After applying ATG RUP7 end-dated users were not able to login after reactivating them.

• Error:- "oracle.apps.fnd.framework.OAException: java.lang.NullPointerExceptionat oracle.apps.fnd.framework.OAException.wrapperException(OAException.java:891)at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequest(OAWebBeanHelper.java:603)"

• Cause:- The issue occurs if the two tables wf_local_user_roles and wf_user_role_assignments are not is synch. But we are bit worried as why these table are not getting updated as soon as user end date is removed. This was working fine in RUP6 instance.

• Temporary workaround :- is below but this needs to be done after every occurunce of user end date removal and that was real pain:-

1. Run the concurrent program below in 2 passes and then bounce Apache:

1.1 "Workflow Directory Services User/Role Validation" Parameters : 100000, Yes, No, No.

1.2 "Workflow Directory Services User/Role Validation" Parameters : 100000, No, Yes, No"

2. Bounce Apache (This step is not ALWAYS required. You may want to test after completing 1.1 and 1.2 to see if the problem is fixed before bouncing.)

• Permanent Resolution:-

1. Go to Workflow Administrator Web Applications


2. Go to Administrator Workflow --> Business Events


3. Search for oracle.apps.global.user.change subcription event


4. Click on Subscription.


5. Click on Pencil button against wf_sso.user_create_rf to disable it.


6. Save changes and replicate the issue.