Update FND USER using API in Oracle Apps

Overview:

     This document help you to Update FND USER using API in Oracle Apps.

API Name:

      FND_USER_PKG.UPDATEUSER

For example: Below example update FND USER --

DECLARE

     lc_user_name  VARCHAR2(90) := ' XX007MN ';

     ld_start_date    DATE         := '09-JUL-2017';

     lc_description   VARCHAR2(50) := 'Work';

     ln_session_id   NUMBER    := 201;

BEGIN

     FND_USER_PKG.UpdateUser ( x_user_name  => lc_user_name,

      x_owner                        => NULL,

      x_session_number         => ln_session_id,

      x_start_date                   => ld_start_date,

      x_description                  => lc_description);

COMMIT;

        dbms_output.put_line('User: ' || lc_user_name || ' Updated Successfully');

EXCEPTION

       WHEN OTHERS THEN

            dbms_output.put_line('Unable to create User due to' || SQLCODE || ' ' || SUBSTR(SQLERRM, 1, 100));

    ROLLBACK;

END;

/

After script completed successfully, check data in base table of User:

SELECT * FROM fnd_user WHERE user_name = 'XX007MN';