Apps 11i Keys shortcut

below are 11i keys quick shortcut it will help to save time

F4 Exit

F5 Clear Field

F6 Clear Record

F7 Clear Block

F8 Clear Form

F11 Query Enter

F12 Count Query

Ctrl + S Save

Ctrl + L List of Values

Ctrl + F11 Query Run

Ctrl + E Edit

Ctrl + Up Delete Record

Ctrl + Down Insert Record

Ctrl + P Print
Ctrl + U Update Record
Ctrl + B Block Menu

Ctrl + K Display list of Keys

Shift + F5 Duplicate Field

Shift + F6 Duplicate Record

Shift + F8 Next Set of Records (Same as Page Down)
Shift + Page Down Next Block
Shift + Tab Previous Field

Shift + Page Up Previous Block

Shift + Ctrl + E Display Error

Page Down Scroll Down (Same as Shift + F8)

Page Up Scroll Up

Tab Next Field
Down Arrow Next Record
Up Arrow Previous Record

Return Return

Who is connected to Oracle apps?

Sometimes the apps dba needs to know who is connecting to apps right now and what responsibly are they using, user id, client ip address and other info.

We can get that up and running in simple steps.

-set the profile option (Sign-On:Audit Level) value to form. By default it is set to none.

-run the concurrent program (OAM Applications Dashboard Collection) this concurrent will fill some tables like fnd_oam_forms_rti with important data like IP address of the client, time, …etc.

-go to Oracle applications manager (OAM) and from the drop down menu choose (forms sessions) this will give you users that are connected to your apps with their responsibilities, user id, time, and which from are they using and a lot of other info.

-To get the ip address of those users you have to click on the (rti pid) filed. This will give you other screen with the information needed.

p.s kindly note that some OS like hp-ux have bug and it will show the ip address like rubbish and it need a patch to be applied in order to get the correct ip address displied.

Who am I ?

select 'User: '|| user || ' on database ' || global_name,
       '  (term='||USERENV('TERMINAL')||
       ', audsid='||USERENV('SESSIONID')||')' as MYCONTEXT
from   global_name;