Tuesday, December 16, 2014

Create User From Backend In Oracle Apps


Execute this script from back-end giving username

DECLARE
  v_user_name  VARCHAR2(30):=UPPER('username');
  v_password   VARCHAR2(30):='oracle123';
  v_session_id INTEGER     := USERENV('sessionid');
BEGIN
  fnd_user_pkg.createuser (
    x_user_name => v_user_name,
    x_owner => NULL,
    x_unencrypted_password => v_password,
    x_session_number => v_session_id,
    x_start_date => SYSDATE,
    x_end_date => NULL
  );
  COMMIT;
  DBMS_OUTPUT.put_line ('User:'||v_user_name||'Created Successfully');
EXCEPTION
  WHEN OTHERS THEN
    DBMS_OUTPUT.put_line ('Unable to create User due to'||SQLCODE||' '||SUBSTR(SQLERRM, 1, 100));
    ROLLBACK;
END;

1 comment:

  1. This way my associate Wesley Virgin's autobiography starts in this SHOCKING AND CONTROVERSIAL VIDEO.

    You see, Wesley was in the military-and soon after leaving-he unveiled hidden, "MIND CONTROL" tactics that the government and others used to get anything they want.

    These are the EXACT same methods lots of celebrities (notably those who "became famous out of nowhere") and elite business people used to become wealthy and famous.

    You probably know how you only use 10% of your brain.

    That's mostly because the majority of your brain's power is UNCONSCIOUS.

    Perhaps that expression has even taken place IN YOUR very own head... as it did in my good friend Wesley Virgin's head seven years ago, while driving an unlicensed, beat-up trash bucket of a car without a driver's license and with $3 in his pocket.

    "I'm very frustrated with going through life paycheck to paycheck! When will I finally succeed?"

    You took part in those types of thoughts, right?

    Your success story is going to start. Go and take a leap of faith in YOURSELF.

    Watch Wesley Virgin's Video Now!

    ReplyDelete