Friday, 5 May 2017

How to find out the Oracle EBS User Creation Details


Hi DBA-Mates,
We will learn about how to check who has created any user in ORACLE EBS R12.

Actually, recently I asked one of my junior to check who has created ORA-DATA user in our EBS account. 
And he is fresher and recently joined but almost he is working from past 6 months. So, hope as a good DBA he should know it. But it’s fine, because may be not before that no one asked him and he also neither thought nor read. 
And I also got an opportunity to tell you guys something new as knowledge’s here.
And I am sure it will be useful here. In above point I have changed user name as ORA-DATA.
So, let’s start the work now.
No need to go anywhere, just look below points: D

1. Open the ORACLE EBS front end URL.
 
Note: If you don’t know the EBS front end URL.

Then Login to backend server.
Connect as apps user.

$ Sqlplus apps/apps

SQL> SELECT home_url FROM icx_parameters;

eg: https://ora-data.blogspot.com:8000/

This above is general query to find out the oracle EBS url in R12.
Now,

2. Login to R12 EBS url as user either SYSADMIN or any other account.

Then click on System Administrator.




3. Then Select below as mentioned:
Security => User => Define.



4. Now, when you will be clicking on “Define”, a new form will be open as shown below:



Here, you will see below contents as:
In above picture, you will see some important things like:
User Name, Password, Description, E-mail etc.

5. Put your cursor in “User Name” text pad and then press F11.
You will see, your User Name text pad will change color from yellow to blue as shown below:


6. Write either User Name or User ID in User name text pad and then press CTRL+F11.

You will see the User’s details as shown below:



7. At the top, you will see “Help” as shown below:



8. Click on “Record History” as shown below:



9 .Then it will show you all the history about the users such as:
Who created this user .
When it was created.
And who has updated that user as shown below:



Some more useful link:


Hope this may Useful and helpful. For any concerns or suggestions, please write to us @ Contact US ora-data.blogspot.com

Thanks,

33 comments:

  1. For Linear and Data Driven frameworks, the tests are typically code-based, and so fairly technical.
    For Boolean types, this is an enumerate type in terms of Pascal.
    Photoluminescent goods don't cause damage to environmental surroundings and supply far better trustworthiness in comparison to
    every other choice out there today.

    ReplyDelete
  2. Good Information Thanks Much!
    My client wants us to implement SSOgen SPGateway with Azure ADFS for EBS 12.2:

    1.Oracle EBS SSO Integrations
    2.SSOgen SPGateway for Oracle EBS

    Any recommendations please?

    ReplyDelete
  3. Hello there!! Nice article on Oracle EBS. Thanks for the info..
    Here is another solution: https://www.ssogen.com/oracle-ebs-sso-integrations/ 
    Thanks..

    ReplyDelete
  4. Saved as a favorite, I really like your web site!

    ReplyDelete
  5. I absolutely love your blog and find many of your post's to be just what I'm looking for.
    Does one offer guest writers to write content for
    yourself? I wouldn't mind creating a post or elaborating on many
    of the subjects you write with regards to here. Again, awesome
    web site!

    ReplyDelete
  6. I am regular visitor, how are you everybody? This piece of writing posted at this web site is really good.

    ReplyDelete
    Replies

    1. Dear User,

      Thank you very much for your feedback and appreciations.
      Yes, we will are doing good... hope you also doing great...

      Regards,
      ora-data Team

      Delete
  7. If the surface is cold but the space beneath the surface
    is heated (like an attic), there might be condensation. These would be the basic woodworking tools available, as
    well as the it's almost guaranteed that you will need at least 2 of
    them for almost any project you are planning. Hiring an authority drywall contractor means you don't have to try to find tips
    about how to plaster your walls anymore.

    ReplyDelete
  8. These plans provide true benefits to the aspirants who wants to create own handed furniture.
    Besides this, every one of the wood book rack undergoes
    a stringent means of quality check. Being a parent, it's solemn duty to produce the
    top possible efforts so your child grows amid positive and blissful environment.

    ReplyDelete
  9. While the former wants a far more open space with lots and lots of colors,; the later would possibly prefer
    a far more formal signature. Ask the kids to assume their new space,
    and what they would prefer inside their bedrooms.
    If you are looking for something around the fun side, you could look at a number of the Pacific Rim furniture taken from
    the countries south in the equator.

    ReplyDelete
  10. If a tragedy were to hit today, will you be ready to keep yourself and your loved ones alive.

    Setting of these video cameras is not a tough job because
    you think it over to be. There are several goods that you can get that will
    help you transform your home and business security.

    ReplyDelete
  11. Unlike other rooms, it is usually a place it doesn't
    seem to have the recognition like other full fledged living rooms, however some of the greatest lively feelings
    and thoughts happen in the bathroom. So once you must
    fix your problem in connection with plumbing
    reputed companies are trustworthy. They also contain warranties
    and useful information that may help you save something or even the other.

    ReplyDelete
  12. But, you will find techniques in order to unlock the secret of driving huge traffic to one's site.

    We all may know about keywords and whatever
    we be paying on their behalf, but to become direct should
    you be paying lots of cents per click then you certainly in reality have
    no idea what you really are doing. One should have an idea in regards to the prices connected with these chemical compounds his or her
    prices can vary according to the base material that is utilized in them.

    ReplyDelete
  13. The second version premiered as a part of SQL Server 2005 in November 2005.
    What we mean by that is usually to simply try asking your pals and
    pay attention to what recommendations they could give you.
    Always when coming up with a trip any time there should be somebody at risk
    to obtain all of the queries and channels them for the right people.

    ReplyDelete
  14. Link eхchangе is nothing else except it iѕ only placing the othеr person's bloɡ link on your paցe
    at proper place and other person will also do sаme
    for you.

    ReplyDelete
  15. Howdy! I know this is kind of off-topic however I needed to ask.
    Does operating a well-established website like yours take a large amount of work?

    I'm completely new to writing a blog however I do write in my journal everyday.
    I'd like to start a blog so I can share my personal experience and
    thoughts online. Please let me know if you have any kind of suggestions
    or tips for brand new aspiring bloggers. Thankyou!

    ReplyDelete
  16. Without any doubt think that you really talked about.
    Your favorite explanation was using the net easy and simple thing
    to know about. I say to you, I just undoubtedly
    secure distressed even while families think of fears how they
    complete in no way understand about. You had been able
    to success that nail following the top part
    as well as characterized out your whole thing devoid of
    side-effects , most people can take an indication. Shall be here we are at
    read more. Thanks a lot

    ReplyDelete
  17. This was it, i was trying to find. Thanks a lot for requiring time to
    publish it on your post. Truly Appreciated. I will be visiting your blog site once
    again as i simply found you publish such an incredible
    things here.

    Also i figured out a site which is devoted to individuals who are eager to
    loose weight eventually. It's about Keto Body Tone that
    is getting popular in the USA, and they are pertaining to other
    nations too. Hope you may enjoy to inspect it out and share your views about Keto Body Tone Diet Product.

    ReplyDelete
  18. Superb, what a webpage it is! This blog provides valuable data to
    us, keep it up.

    ReplyDelete
  19. Excellent blog right here! Also your site quite a bit up very fast!
    What host are you using? Can I get your associate hyperlink for your host?
    I wish my web site loaded up as fast as yours lol

    ReplyDelete
  20. I was recommended this web site through my cousin. I
    am no longer certain whether this publish is written through
    him as nobody else know such targeted approximately my trouble.

    You're incredible! Thanks!

    ReplyDelete
  21. whoah this blog is excellent i love studying your posts.
    Stay up the good work! You know, many people are hunting round
    for this info, you could help them greatly.

    ReplyDelete


  22. Hello, Good Article you know your article it's useful me and Thanks for Sharing Information.
    Oracle Institute in Delhi

    ReplyDelete
  23. wow, great blog! I learned a lot and Really nice content. Thank you for sharing this unique information about this topic.. oracle training in chennai

    ReplyDelete
  24. Thanks for sharing this great information on Oracle PPM Cloud. Actually I was looking for the same information on internet for Oracle Project Portfolio Management (PPM) Cloud Tutorial and came across your blog. I am impressed by the information that you have on this blog. It shows how well you understand this subject, you can learn more about PPM Cloud by attending Oracle PPM Cloud Training .

    ReplyDelete
  25. Worth reading! Our experts also have given detailed inputs about these trainings & courses! Presenting here for your reference. Do checkout Aws training in chennai & enjoy learning more about it.

    ReplyDelete
  26. Study Amazon Web Services for making your career as a shining sun with Infycle Technologies. Infycle Technologies is the best AWS training institute in Chennai, providing complete hands-on practical training of professional specialists in the field. In addition to that, it also offers numerous programming language tutors in the software industry such as Oracle, Python, Big Dat, Hadoop, etc. Once after the training, interviews will be arranged for the candidates, so that, they can set their career without any struggle. Of all that, 200% placement assurance will be given here. To have the best career, call 7502633633 to Infycle Technologies and grab a free demo to know more.
    No.1 AWS Training Institute in Chennai | Infycle Technologies

    ReplyDelete
  27. Grab the Oracle Certification in Chennai from Infycle Technologies, the best software training institute, and Placement center in Chennai which is providing professional software courses such as Data Science, Artificial Intelligence, Cyber Security, Big Data, Java, Hadoop, Selenium, Android, and iOS Development, DevOps, etc with 100% hands-on practical training. Dial 7502633633 to get more info and a free demo and to grab the certification for having a peak rise in your career. Grab Oracle Certification in Chennai | Infycle Technologies

    ReplyDelete
  28. Infycle Technologies, the top software training institute and placement center in Chennai offers the No.1 Digital Marketing course in Chennai for freshers, students, and tech professionals at the best offers. In addition to Digital Marketing, other in-demand courses such as DevOps, Data Science, Python, Selenium, Big Data, Java, Power BI, Oracle will also be trained with 200% practical classes. After the completion of training, the trainees will be sent for placement interviews in the top MNC's. Call 7504633633 to get more info and a free demo.

    ReplyDelete
  29. Thanks a lot. Your instructions are clear and easy to understand.

    ReplyDelete
  30. ADF training institute are very limited and we are one of the best Azure data factory training institute in Hyderabad more details visit my website linkhttps://azuretrainings.in/azure-data-factory-training-in-hyderabad/

    ReplyDelete
  31. Nice thanks for sharing informative post like this keep posting if like more details visit my website linkhttps://cybersecuritymasters.in/

    ReplyDelete

Thank you for your comments and suggestions. It's good to talk you.