Basic Questions
What is the difference between a public and a private synonym?
Only user can access private synonym, any user on the database can access public synonym
What are the database objects that are registered with Oracle Applications?
Tables,Sequence and Views.
What are the types of functions in AOL?
form function and non form function
What are different types of menus that can be defined In AOL?
Global Menu
Standard Menu
How many types of users can be defined in System Administration?
Employee
Customer
Supplier
Multiple functions can be defined on the Same form?
Yes
What is the significance of basepath that is specified at the point of application development?
The base path in env file helps the oracle apps to search the form,reports or program at an appropriate place.
What is the environment variable that has to be modified in application development process?
appl_top
Appl_full
Can you draw the directory structure of a specific product?
prodappltauq11.5.0formsus
reportsus
log
out
What files are stored by the bin subdirectory of a module?
.sh and .exe,.dll file
Can you register SQL * LOADER programs with AOL?
Yes, there is an option for sql* loader
How PL/SQL programs are registered with AOL?
1. create a PL/SQL programs in apps user
2. define the executables in navigation : concurrent>executables
3. assign the executable to the concurrent program in
navigation :
concurrent>program>define
4. assign the concurrent program to the request group
in navigation:
security>responsibility>request
What are the two mandatory parameters that should be incorporated while writing Pl/sql programs?
errorbuf and retcode.
Can you register out parameters also for a plsql concurrent program?
In pl/sql concurrent program we should define only IN parameter.
What is program incompatibility rules?
Program incompatibility rules is enforced by comparing program definitions for Requested programs with those programs already running in an Oracle username designated as a logical database.
What is a concurrent manager?
Concurrent manager A process manager on the Applications database server that coordinates the concurrent processes generated by users’ concurrent requests.
Can a concurrent manager execute multiple requests at a time?
Yes.
What is a request group?
It is a collection of concurrent program ,reports, sets,application, stages.
What is a request set?
Request sets allow you to submit several requests together using multiple execution paths. A request set is a collection of reports and/or programs that are grouped together. You can thus submit the reports and/or programs in a request set all at once using a single transaction.
What is the full form of SRS?
Standard Request Submission
Which files are mandatory for a form development process?
template.fmb
Appstand.fmb
What are the object groups that are used by Template.fmx?
STANDARD_PC_AND_VA
STANDARD_TOOLBARS
STANDARD_CALENDER
STANDARD_FOLDER
QUERY_FIND
What is the name of standard menu used by oracle applications forms design?
fndmenu.mmx
