API’s to Create User,Reset Password and Add Responsibility

April 26, 2011, Category: AOL, APIs, Script · 7 Comments

API’s to Create User,Reset Password and Add Responsibility

I have created few queries using Oracle provided package:’FND_USER_PKG’. These queries might be very useful when you donot have the Oracle Apps front end access or you like to get in done through backend.

Using the below query, you can create a User in Oracle application.Just pass username, password and email id as parameters and it will create a user.

May a times we forgot the apps password. Then you can use the below query to resent the password just in few seconds.

Use the below query to add a responsibility to a user. The advantage here is that you donot require system administrator responsibility access to add a responsibility.

Related Posts:

Related Posts

Query to Get All Active Employee Details!

This is a useful query that shows all the active employees and workers as of SYSDATE. It contains columns like Full Name, Last Name, First Name, Person Type, Employee Flag,…….



Register Custom TableHow to Create a Custom Event Alert to Fire against a Custom Table?

An event alert is a database trigger that tells you when data in an object within the database has been changed.  Event alerts can be configured to trigger an action,…….



Procure to Pay (P2P) Query in Oracle Apps!

Procure to Pay (P2P) Lifecycle is one of the important Process in Oracle Applications. Procure to Pay means Procuring Raw Materials required to manufacture the final or finished Goods from a Supplier…….



API to Delete Values in Value Sets!

Here is a useful API to delete the values in a Value set in AOL.

Related Posts:API to Load Values into Value SetsAPI to Create a New Organization in…….



API to Create a New Organization in Oracle HRMS

HR_ORGANIZATION_API.CREATE_ORGANIZATION This API creates a new organization within the scope of an existing business group. In Parameters: p_validate: If true, then validation alone will be performed and the database will…….