Exforsys

Oracle Apps 11i

  1. ERP Overview
  2. Oracle Apps 11i: Overview of popular ERP Products
  3. Oracle Apps 11i: Advantages of Oracle E-Business Suite
  4. Oracle Apps 11i : Getting started with Oracle Applications
  5. Oracle Apps 11i: Internationalization Support and Multiple Reporting Currencies
  6. Oracle Apps 11i : File System
  7. Oracle Apps 11i Installation - System Requirements
  8. Oracle Apps 11i - Using Rapid install and the Steps Before Apps Installation
  9. Single Node and Multi Node Installation Part 1
  10. Single Node and Multi Node Installation Part 2
  11. Oracle Apps Application Framework
  12. Oracle Apps Table Registration API
  13. Oracle Apps Concurrent Processing
  14. Oracle Apps Concurrent Library Window
  15. Oracle Apps Message Dictionary
  16. Oracle Apps Flex fields
  17. Oracle Apps Implementing Key Flex field and Descriptive Flex field
  18. Oracle Apps Template Form
  19. Special Triggers in the Template Form in Oracle Apps 11i
  20. Creating New Forms in Oracle Apps 11i
  21. Creation of Master Detail Block in Oracle Apps 11i
  22. Registering New Forms in Oracle Apps 11i
  23. Oracle Apps 11i: Setting up Chart Of Accounts (COA)
  24. Oracle Apps Sys Admin - Users and Responsibilities
  25. Oracle Apps 11i : Creating Journals through Oracle GL
  26. Oracle Apps 11i : Suppliers
  27. Oracle Apps 11i : Asset Management - Asset Book Positioning
  28. Oracle Apps 11i : Asset Management - Asset Books Regions
  29. Oracle Apps 11i : Asset Management - Manual and Quick Additions
  30. Oracle Apps 11i : Asset Management - Mass Additions
  31. Oracle Apps 11i : Asset Management - Asset Adjustments
  32. Oracle Apps 11i : Asset Management - Mass Transfers
  33. Oracle Apps 11i : Asset Management - Depreciation
  34. Oracle Apps 11i : Asset Management - Retirements
  35. Oracle Apps 11i : Asset Management - Journal Entries
  36. Oracle Reports 6i

Ads


Home arrow Technical Training arrow Oracle Apps 11i

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

Page 3 of 3
Author : Exforsys Inc.     Published on: 9th May 2005    |   Last Updated on: 13th Apr 2011

Oracle Apps 11i : Getting started with Oracle Applications

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.

Ads

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

Ads

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












 
This tutorial is part of a Oracle Apps 11i tutorial series. Read it from the beginning and learn yourself.

Oracle Apps 11i

  1. ERP Overview
  2. Oracle Apps 11i: Overview of popular ERP Products
  3. Oracle Apps 11i: Advantages of Oracle E-Business Suite
  4. Oracle Apps 11i : Getting started with Oracle Applications
  5. Oracle Apps 11i: Internationalization Support and Multiple Reporting Currencies
  6. Oracle Apps 11i : File System
  7. Oracle Apps 11i Installation - System Requirements
  8. Oracle Apps 11i - Using Rapid install and the Steps Before Apps Installation
  9. Single Node and Multi Node Installation Part 1
  10. Single Node and Multi Node Installation Part 2
  11. Oracle Apps Application Framework
  12. Oracle Apps Table Registration API
  13. Oracle Apps Concurrent Processing
  14. Oracle Apps Concurrent Library Window
  15. Oracle Apps Message Dictionary
  16. Oracle Apps Flex fields
  17. Oracle Apps Implementing Key Flex field and Descriptive Flex field
  18. Oracle Apps Template Form
  19. Special Triggers in the Template Form in Oracle Apps 11i
  20. Creating New Forms in Oracle Apps 11i
  21. Creation of Master Detail Block in Oracle Apps 11i
  22. Registering New Forms in Oracle Apps 11i
  23. Oracle Apps 11i: Setting up Chart Of Accounts (COA)
  24. Oracle Apps Sys Admin - Users and Responsibilities
  25. Oracle Apps 11i : Creating Journals through Oracle GL
  26. Oracle Apps 11i : Suppliers
  27. Oracle Apps 11i : Asset Management - Asset Book Positioning
  28. Oracle Apps 11i : Asset Management - Asset Books Regions
  29. Oracle Apps 11i : Asset Management - Manual and Quick Additions
  30. Oracle Apps 11i : Asset Management - Mass Additions
  31. Oracle Apps 11i : Asset Management - Asset Adjustments
  32. Oracle Apps 11i : Asset Management - Mass Transfers
  33. Oracle Apps 11i : Asset Management - Depreciation
  34. Oracle Apps 11i : Asset Management - Retirements
  35. Oracle Apps 11i : Asset Management - Journal Entries
  36. Oracle Reports 6i
 

Comments