Create Simple Queries

 
As a user you must have access to the 'Profile System Values’ (FND_FNDPOMPV) function to use this functionality or be assigned one of the following Profile Options depending on your version of the Wizard:
 
-     More4Apps: XXX Nominated Sysadmin for user maintenance (XXX represents the Wizard code e.g. GLW is General Ledger Wizard)
 
-     More4Apps: XXX Custom Query Manager (XXX represents the Wizard code e.g. GLW is General Ledger Invoice Wizard)
 
As a user you must have access to the 'Profile System Values’ (FND_FNDPOMPV) function to use this functionality.
 
If you are familiar with SQL Queries you can either write them directly by creating a new Query from the 'Manage Queries' window or copy/paste it from a SQL client tool like TOAD or SQL Developer.
Note:  When writing them directly to insert a carriage return, click 'Ctrl + Enter'.
 
1.     Click the ‘Manage Queries’ button on the ‘Custom Query’ ribbon:
 
 
2.     The form will open and choose ‘New’ from the ‘Action’ LOVs:
 
 
For more information on how to create SQL Queries, refer to section Create Query Sets below.
 
Refer to section:
Functionality Security
Create Query Sets
Modify Query Sets
Export Query Sets
Import Query Sets
Date Time Attributes
Query Set SQL Syntax
Downloading
Mapping
Query Set Selection Security
Query Migration Option