Changing front end password using script

Following script can be used for changing the password of a user:

select fnd_web_Sec.change_password(‘PRAY‘,’Welcome1234’) from dual;

 

Following block can be used to assign the user with the responsibilities from backend:

BEGIN

    fnd_user_pkg.addresp(

        ‘PRAY’,    ‘SYSADMIN’,  ‘SYSTEM_ADMINISTRATOR’,    ‘STANDARD’,

        ‘Add Responsibility to USER using pl/sql’,  SYSDATE,

        SYSDATE + 100   );

    COMMIT;

    dbms_output.put_line(  ‘Responsibility Added Successfully’

    );

EXCEPTION    WHEN OTHERS THEN

        dbms_output.put_line(

            ‘ Responsibility is not added due to ‘ ||  sqlcode    ||  substr(

                sqlerrm,     1,100)

        );

        ROLLBACK;

END;

/

Advertisements

Opening Oracle Apps Forms using Mac

Objective

Opening Oracle Apps Forms using Mac.

Java Version

Java 8 Update 131

Navigation

System Preferences –> Java –>Reopen the Java control Panel –> Updates

Uncheck the option “Check for updates Automatically”

 

Go to Security Tab –> Edit site list –> Add

Add the URL of the instance that needs to be accessed.

Screen Shot 2017-07-12 at 8.43.59 PM