Tuesday, October 29, 2019

API to end date the User in Oracle Apps - FND_USER_PKG.UPDATEUSER


Below script is used for updating User end date 


DECLARE
    lc_user_name       VARCHAR2(100)  := 'SGUDURU';
    ld_user_end_date   DATE  := SYSDATE+1000;
BEGIN
   fnd_user_pkg.updateuser
   (  x_user_name               => lc_user_name,
      x_owner                   => NULL,
      x_unencrypted_password    => NULL,
      x_start_date              => NULL,
      x_end_date                => sysdate+1000,
      x_password_date           => sysdate+1000,
      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;
/

6 comments:

  1. Replies
    1. Machine Learning Projects for Final Year machine learning projects for final year

      Deep Learning Projects assist final year students with improving your applied Deep Learning skills rapidly while allowing you to investigate an intriguing point. Furthermore, you can include Deep Learning projects for final year into your portfolio, making it simpler to get a vocation, discover cool profession openings, and Deep Learning Projects for Final Year even arrange a more significant compensation.

      Python Training in Chennai Project Centers in Chennai

      Delete
  2. Generally, we will in general partner innovation with the more youthful age, yet, more established grown-ups are shockingly capable with a scope of present day innovation. For instance, 59% of Americans matured 65 or more go on the web and 77% of this populace use cellphones.
    xender

    ReplyDelete
  3. It is included in my habit that I often visit blogs in my free time, so after landing on your blog. I have thoroughly impressed with it and decided to take out some precious time to visit it again and again. Thanks. Expert secrets

    ReplyDelete
  4. What a fantabulous post this has been. Never seen this kind of useful post. I am grateful to you and expect more number of posts like these. Thank you very much. note taking apps

    ReplyDelete