Script to reset User password in Oracle Applications

Script to reset user password in oracle applications

We can use the in build API to reset the user password from backend.

API: fnd_user_pkg.changepassword this API accepts two parameters one is USER NAME and other is New Password.

Below is the anonymous block to reset password.

SET SERVEROUTPUT ON;

How to create Lookups in Oracle E-Business Suite

Lookup in Oracle Apps

What is lookup in oracle apps?

Lookup is nothing but a set of codes and their meaning.

E.g. in HCM or HRMS we have users, a user can be active or Inactive.

For this purpose oracle has provided the standard lookup called “ACTIVE_INACTIVE”.

How to Create and Use Messages in Oracle Apps |Oracle E-Business Suite

Messages in Oracle Apps:

Oracle application uses a message dictionary to display the messages in Forms, Reports, PLSQL code, OAF, and ADF. 

Oracle has given a mechanism to define your own messages, it provides you the flexibility to define and store your messages in a message dictionary and you can display them as error/warning/notes.

How to Enable Trace and Read Trace Files in Oracle Apps |Oracle E-Business Suite

How to enable trace for concurrent program?

Trace is used to identify long running or time consuming query/queries due to which performance of concurrent program is decreasing.

By identifying the time taking queries we can tune those queries to increase the performance of concurrent program.

What is/How to Create Profile Options in Oracle Apps |Oracle E-Business Suite

Profile Options

In simple terms you can say that profile options are used to determine how the application should work. In other terms Profile Options in oracle apps are used to control the behavior of application.

Types of Profile Options:

There are two types of profile option. These are used to provide control and visibility.

Types of Value Sets in Oracle Applications |Oracle E-Business Suite

Values Sets in Oracle Apps

What is a Value Set?

Set means number of items put together, so in this way you can say that Value set is nothing but a set of values which are put together and which can help users to input their values correctly without any text errors.

Values set can be used in key Flex Fields, Descriptive flex Fields and as a program parameters.

How to Create Concurrent Program in Oracle Apps |Oracle E-Business Suite

Create and register a concurrent program in oracle apps

Oracle applications is all about the concurrent program, most of the activities are performed by concurrent programs, so let’s see how to create a concurrent program in oracle apps

Here the question arises what is the concurrent program?

A concurrent program is an executable file, if you want to perform an activity such as generating a report, creating invoices, posting a journal and etc. these all tasks can be done by creating an executable file, an executable file can be anything such as PLSQL code, oracle reports, HOST, Java program and etc.

Here are the steps to create an executable and register that executable file as a concurrent program.

How to Create Users in Oracle Apps |Oracle E-Business Suite

Create a USER and Assign responsibility in Oracle Apps.

If you want to access oracle application then you need to have an account, If you have system administrator responsibility then you can create accounts for others.