Sunday, August 2, 2009

Creation of User

1) Open the internet Explorer connect to Oracle Applications
2) Enter the User Name: OPERATIONS
Password : WELCOME
3) Select the Responsibility called 'System Administrator'
4) Open the User form.
Security => User =>Define

5) Enter User Name and Password attach the Responsibilities whatever we required for System Administrator Application Developer

6) Exit from the Applications
File => Exit Oracle Applications

7) Connect to Oracle apps enter new user name password system will shows the message like ‘Password Has Expired'

8) Enter the New Password Press Ok Button

Short Cuts:
==========

1) To Query All the Records Press CTRL+F11
2) To Query Specific Records
i) Open the Form
ii) Press F11 (Form will comes into Query mode)
iii) Enter Search Criteria in any field
iv) Press CTRL+F11
3) To Close Form = F4
4) To Save the Records CTRL+S

Effective Date From and To:
=======================
In most of the Oracle Application forms we will find two field like
Effective Date From
Effective Date To

In some of the forms once we create records and save. We can not delete from database
that time we can go for Disable/Enable the record by using these two fields

Finding Table Names/Column Names:
==============================
1)Help => Record History which will shows the Table Name
2)Help Menu=>Diagnastics=>Examine=>Enter the Password(APPS)=>We can find the Column Name

WHO Columns:
==========
WHO Column Will be used to find out the History of the record
we can find from front End Also
Help=>Record History

CREATED_BY - Which User has created the Record (Userid)
CREATION_DATE - at what time user has created (SYSDATE)
LAST_UPATED_BY -Which User has updated recently(Use rid)
LAST_UPDATE_DATE -at what time user has Updated (SYSDATE)
LAST_LOGON_DATE - At what time user last Login Time

Find the Login Username:
======================
Help Menu=>About Oracle Applications


Open Internet Explore and Connect to Oracle Applications


Select "System Administrator" responsibility.

Navigation: System Administrator ==> Security:User==>Define

Enter the required fields and add Some responsibilities.The Save the form ( Cntl+S)

Exit from Applications

File => Exit Oracle Applications

Connect to Oracle apps enter new user name password


We have to change the password. Enter the new password and press OK button.


User Details Stored in FND_USER table in APPLICATION OBJECT LIBRARY