Sunday, October 22, 2017

API to Reset Oracle APPS Password From Backend

DECLARE
   v_user_name      VARCHAR2 (100) := 'NUSER';
   v_new_password   VARCHAR2 (100) := 'welcome123';
   v_status         BOOLEAN := NULL;
BEGIN
   v_status := fnd_user_pkg.changepassword (v_user_name, v_new_password);

   COMMIT;
   DBMS_OUTPUT.put_line (
      'Password is changed successfully for the user ' || v_user_name);
EXCEPTION
   WHEN OTHERS
   THEN
      DBMS_OUTPUT.put_line (
            'Error encountered while setting new password to the user and the error is '
         || SQLERRM);
END;

No comments:

Post a Comment

SupplierAddressImportTemplate.xlsm South Africa Suburb Field mapping in POZ_SUPPLIER_ADDRESSES_INT

Suburb mpping in Supplier Address Import Template will be mapped to Address Element Attribute2 (HZ_LOCATIONS. ADDR_ELEMENT_ATTRIBUTE2)