Exforsys.com
 
Home Tutorials Oracle Apps
 

Oracle Apps 11i : Getting started with Oracle Applications

 

Oracle Apps 11i : Getting started with Oracle Applications - Page 3

Page 3 of 3


Query Form


The Define shown in the figure 9 above is used to create Login Ids for the Oracle Applications users by the System Administrator. The same form can also be used to query the existing users’ data. To view (query) the existing data go to View->Query By Example->Enter to enter the query criteria as shown in the figure 10 below.



Figure 10. Query Method


Once you click on Enter as shown in the form above, the Define form switched mode to query mode and the color of the fields changes to BLUE. Enter a value in a field in the form above for which you want to query the data.

If you want to query for your username, type your username in the ‘User Name’ field on the form. The form would look like as shown in the figure 11 below.



Figure 11. Enter Query


To fetch the results matching the entered criteria, you need to run the query. This can be done by clicking on View->Query By Example->Run as shown in the figure 12 below.



Figure 12. Run Query


The data would be displayed in following fashion as shown in the figure 13 below. The form shows a lot of details about the username entered in the query. All the responsibilities attached to the user name are shown in the form.



Figure 13. Query Results



Keyboard Shortcuts

The same process can be used to query data on any form in Oracle Applications. You can also use the keyboard shortcuts for entering and running the query. For example, F11 key puts the form in the query mode and Ctrl + F11 runs the query. You can get the list of the complete key board shortcuts by clicking on Help->Keyboard Help as shown in the figure 14 below



Figure 13. Keyboard Shortcuts
















First Page: Oracle Apps 11i : Getting started with Oracle Applications


Read Next: Oracle Apps 11i: Internationalization Support and Multiple Reporting Currencies



 

 

Comments


Srilatha Thirunagari said:

  Good basics for beginers
November 4, 2005, 5:47 pm

pawan27 said:

  Hi to every one,<br />
iam pvan working as oracle developer in Botswana.<br />
my feeling is it is very useful site to learn new technologies who are working in other feilds. for me it is excellent site to me. one more request to site administrators i did not found classes on DWH and Java basisc.
June 9, 2006, 8:20 am

alpkumar said:

  it is being very very useful to anyone.<br />
Thanks for providing the clear concepts.
June 16, 2006, 4:46 pm

Tajammul said:

  It is indeed very helpful for beginners...
thank you
November 11, 2006, 2:40 am

Pushpendra Tomar said:

  Absolutely perfect tutorial for those who are completely new to Oracle Applicaitons 11i.
December 5, 2006, 8:31 am

kik said:

  as beginers so many people doesnt know more...but like these presentaions will help them from the scratch...!!!
January 12, 2007, 2:37 am

babunarendra said:

  hi my self narendra working as oracle developers it is very useful for me to start the 11i suite.please post OM,Po Materials....
January 19, 2007, 5:28 am

saisri said:

  It is very useful for freshers like me.can anyone please list some tools which r in demand in testing industry
March 10, 2007, 5:39 pm

satish kumar said:

  It is very useful for fresher like me .Kindly post the OM,AR,INV materails........
May 11, 2007, 10:05 am

Santosh Mudaliar said:

  I think the step by step approach given in this site is really handy for new comers to learn the product.

Its really a great efforts.

Thanks for such a wonderful platform.

Santosh Mudaliar
santosh.mudaliar@rediffmail.com
May 22, 2007, 12:11 pm

RAHUL GUPTA said:

  I was desperately looking for a site that will help the begginers of ORACLE 11 apps and luckly I got this site .

Regards
RAHUL
DBA
ecengineer84@gmail.com
July 4, 2007, 2:55 pm

Laxmidhar panda said:

  really this will help me a lot
September 5, 2007, 7:09 am

gary poole said:

  can someone comment on why some of the responsibilities have forms and others appear to go to html?
For example creating a project via Proj billing super user goes to forms while Project super user will go to a web environment. I just don't understand why they are not created the same way. Thanks
October 13, 2007, 7:28 pm

Manav said:

  A very good start for new comers......

Thanks a lot
July 11, 2008, 2:22 am

Altaf Hussain Khan said:

  I found this site useful for beginners.
October 23, 2008, 1:49 am

ricky said:

  thanks for giving clear idea about how to assign responsibility.
November 8, 2008, 3:35 pm

praveen said:

  How can we find Applications URL in Apps DBA ?
November 9, 2008, 10:56 am

Sundaramoorthy Uvaraj said:

  Really this site is very informative and helping a lot for ERP consultants
November 15, 2008, 10:28 am

sandee[ narayan said:

  its gives you a very precise knowledge of technology.
December 5, 2008, 2:18 am

sandee narayan said:

  its gives you a very precise knowledge of technology.
December 5, 2008, 8:29 pm

Rohit Wagdarikar said:

  Presentation Format is very good .......
December 9, 2008, 5:58 am

Subrat Majhee said:

  The pictorial presentation is really appreciated.Good Job ! Thanks !
December 13, 2008, 2:53 pm

0 said:

  I am very Lucky to see this site
December 29, 2008, 4:46 am

mayank said:

  this is the perfect material for new comers like me...can anyone please send me some more material regarding 11i....

thanks and regards
mayank
junior DBA
December 31, 2008, 4:56 am

Mak said:

  yes this is no doubt good try, i would highly appreciate
i need the pictorial metarial like this if i can get easily please
regarding financials...
regards
Mak
January 29, 2009, 6:32 am

Post Your Comment:

Members Please Login
Your Name:*
e-mail ID:(required for notification)*
Image Verification: 
 
 Subscribe    

Sponsored Links

 

Subscribe via RSS


Get Daily Updates via Subscribe to Exforsys Free Training via email


Get Latest Free Training Updates delivered directly to your Inbox...

Enter your email address:


 

Subscribe to Exforsys Free Training via RSS
 

 
Partners -  Privacy and Legal Policy -  Site News -  Contact   Sitemap  

Copyright © 2000 - 2010 exforsys.com. All Rights Reserved

Page copy protected against web site content infringement by Copyscape