Search This Blog

Monday, June 30, 2025

Oracle EBS Update FND_USER user password

 DECLARE

    lc_user_name       VARCHAR2(100)  := 'AFZAL_BAIG';

--    ld_user_end_date   DATE  := SYSDATE;

l_password varchar2(40) := '123456';



BEGIN

   fnd_user_pkg.updateuser

   (  x_user_name               => lc_user_name,

      x_owner                   => NULL,

      x_unencrypted_password    => l_password,

      x_start_date              => NULL,

      x_end_date                => NULL,

      x_password_date           => to_date('2','J'), --forcing user to reset the password after the first login

      x_password_lifespan_days  => NULL,

      x_employee_id             => NULL,

      x_email_address           => NULL

   );


 COMMIT;



EXCEPTION

  WHEN OTHERS THEN

    ROLLBACK;

    DBMS_OUTPUT.PUT_LINE(SQLERRM);

END;

Sunday, June 29, 2025

EBS R12 Error in AME workflow when new approver is added

 Solution: 

1. Remove the employee name in the fnd_user form and add again and save.

2. Check tables wf_roles, wf_user_roles compare with the working employee.

3. In the AME Approval list check if the approvers are coming dynamic, then change it to the static and all the approvers.


Clear cache and test again.