Total Pageviews

Thursday, 8 June 2023

EBS : Password change from backend in Oracle APPS

 How to changes Password from Backend in Oracle Apps

DECLARE
           V_pwdchanged BOOLEAN;

      BEGIN
         v_pwdchanged := fnd_user_pkg.changepassword('TCHHARDS','12345');
         IF v_pwdchanged THEN
         DBMS_OUTPUT.put_line('password changed Sucessfully');
         ELSE
         DBMS_OUTPUT.put_line('Failed to change the Password');
        END IF;
      END;
      

*********************************************************************************
#Oracle Apps #EBS #fnd_user_pkg #Password 

No comments:

Post a Comment

FUSION: Purchasing Query

  1) ---------CPA to PO Amount---------- select poh.segment1, (select sum(nvl(cpol.quantity,1)* cpol.unit_price) from po_headers_all cpoh,po...