How to setup a forms function in R12 to launch an URL

First set the Profile 'Restricted Text Input' to 'No' for your User.

Then create a form function like below:

Functional Administrator > Core Services > Function > Create (button)

Name: XX_GOOGLE
Code: XX_GOOGLE
Type: SSWA jsp function
Maintenance Mode Support : none
Context Dependance: Responsibility
(press continue button)
HTML Call: javascript:void window.open("http://www.google.com")
Leave other fields blank

Add to HR_EMPLOYEE_DIRECT_ACCESS_V4.0 menu:

500 XX Google XX_GOOGLE

This will pop up your external webpage in a new window.

The issue is that it only works from the Navigator framework page (not from within Core Forms)

Cheerssss!!!

Bulk Password Change Script

After running below script, system will ask you to change the password.

begin
fnd_user_pkg.updateuser(
x_user_name => '204020779'
, x_owner => 'CUST'
, x_unencrypted_password => 'change123',
x_password_date => to_date('2','J')
);
commit;
end;

After running below script, system will not ask you to change the password.

BEGIN

FND_USER_PKG.UPDATEUSER(x_user_name            => 'teamsearch'

                       ,x_owner                => 'SEED'

                       ,x_unencrypted_password => 'oracle@123'

                       ,x_password_date        => SYSDATE + 500);

END;

Self - Service Persanalization Profiles

1. Personalize Self-Service Defn
2. FND: Personalization Region Link Enabled