HOW-TO: Setup the Self Service Password Request Workflow

Posted by in Oracle EBS
No Comments

How often a password reset is required? How long does it take to find time to reset the password manually? Implementing the Self Service Password Reset can save a lot of manual workload and can be done in few easy steps. The workflow, before the to reset the password, will ask the user to confirm by email the new password request. This prevents any other user, to reset passwords without authorization.

Here the setup to be done in the TESTING ENVIRONMENTS ONLY.

1. Execute the following queries that will change all the email addresses from the po_vendor_sites_all table
SQL> update wf_notifications set status = ‘CLOSED’, mail_status=’SENT’,end_date=SYSDATE where status != ‘CLOSED’;

SQL> update po_vendor_sites_all set email_address=’test@company.com’,remittance_email=’test@company.com’;

2. Make sure the Override Address is cleared.

System Administrator -> Workflow -> Oracle Application Manager -> Workflow Manager -> Service Components -> Workflow Notification Mailer -> View Details -> Set Override Address
Click ‘Clear Override Address’

In the TESTING ENVIRONMENTS this should be done only after the STEP 1. Otherwise the PO created for testing purposes will be really sent to the suppliers.


 


 

3. After it’s possible enable the link ‘Forgot your password?’ in the login page setting the profile option ‘Local Login Mask’ at site level to value ’40’.

System Administrator -> Profile -> System

It’s important to make sure that the user accounts in the system have a valid email address set. In other case the risk is that the password can be sent to the wrong user.

In case something is wrong with the email setting, it’s possible to check the Workflow Notification Mailer setting
System Administrator -> Workflow -> Oracle Application Manager -> Workflow Manager -> Service Components -> Workflow Notification Mailer -> Edit

In PROD it’s enough to execute step 2 and step 3. Never execute step 1 in PROD.

Was it easy? :D

# # #

Reply