Tutorials Oracle Apps Oracle Apps 11i : Getting started with Oracle Applications Oracle Apps 11i : Getting started with Oracle Applications - Page 2 Oracle Apps 11i : Getting started with Oracle Applications - Page 3Query 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
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
| Good basics for beginers |
|
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. |
|
it is being very very useful to anyone.<br /> Thanks for providing the clear concepts. |
|
It is indeed very helpful for beginners... thank you |
| Absolutely perfect tutorial for those who are completely new to Oracle Applicaitons 11i. |
| as beginers so many people doesnt know more...but like these presentaions will help them from the scratch...!!! |
| hi my self narendra working as oracle developers it is very useful for me to start the 11i suite.please post OM,Po Materials.... |
| It is very useful for freshers like me.can anyone please list some tools which r in demand in testing industry |
| It is very useful for fresher like me .Kindly post the OM,AR,INV materails........ |
|
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 |
|
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 |
| really this will help me a lot |
|
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 |
|
A very good start for new comers...... Thanks a lot |
| I found this site useful for beginners. |
| thanks for giving clear idea about how to assign responsibility. |
| How can we find Applications URL in Apps DBA ? |
| Really this site is very informative and helping a lot for ERP consultants |
| its gives you a very precise knowledge of technology. |
| its gives you a very precise knowledge of technology. |
| Presentation Format is very good ....... |
| The pictorial presentation is really appreciated.Good Job ! Thanks ! |
| I am very Lucky to see this site |
|
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 |
|
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 |
