Interview Questions - AOL & SYSADMIN

Explain the steps involved in Report registration.
A) i)Through FTP we have to put the Report Builder .rdf file in the specific application.
ii)Go to Sysadmin -> Concurrent ->Program -> Executable to specify the Executable file name.
iii)Go to Sysadmin -> Concurrent ->Program ->Define to define the concurrent program and necessary parameters.
iv)Add the Concurent Program to Concurrent request Group.

What is the package used for Table registration and similarly what other objects can you register at SQL*PLUS?
A) The Package is AD_DD.
We have different Procedures to Register different Objects.
To Register table : AD_DD.register_table.
To Register Columns: AD_DD.register_column
To Delete Table : AD_DD.delete_table
To Delete Column : AD_DD.delete_column
To register Primary Key:AD_DD.register_primary_key
To Update Primary Key:AD_DD.update_primary_key
To delete Primary Key:AD_DD.delete_primary_key_column

What is the .env filename used for setting environment variables for an application?
A) Defines the environment variables for your Oracle Applications
installation. The environment files include .env and
adovars.env (for UNIX platforms). The .env file contains
application basepath variables for Oracle Applications products and
other environment variables and is regenerated automatically by
Oracle Applications administration utilities.

Explain the steps involved in registering a concurrent request set and what preventive measures should you take to avoid an infinite loop of requests?

What are the who columns? When they are required? How do you enable them?

A) CREATED_BY,CREATION_DATE LAST_UPDATED_BY,LAST_UPDATE_DATE
LAST_UPDATE_LOGIN, REQUEST_ID, PROGRAM_APPLICATION_ID
PROGRAM_ID, PROGRAM_UPDATE_DATE
The WHO Columns feature reports information about who created or updated rows in Oracle Applications tables.
Call FND_STANDARD.SET_WHO in PRE–UPDATE and
PRE–INSERT to populate these fields.

What is the difference between parameter prompt and token? When do you take
a “SEGMENT” as default type?

A) Parameter Prompt is a prompt instead of the parameter name in the Parameters window of the Submit Requests window.
Token is the exact reference of the Parameter of the report.
If we want to use the value entered in a prior segment of the same flexfield window then, we will take the default type as a Segment.

Under which directory .sql file is placed at OS level?
A) //11.5.0/sql
Suppose If you have developed a form for GL. Where do you place the .fmb file and .fmx file?
A). fmb File : /au/11.5.0/forms/US
. fmx File: //11.5.0/forms/US
What are different method of Execution Methods?
A): Host :The execution file is a host script.
Oracle Reports:The execution file is an Oracle Reports file.
PL/SQL Stored Procedure:The execution file is a stored procedure.
SQL*Loader:The execution file is a SQL script.
SQL*Plus:The execution file is a SQL*Plus script.
Spawned:The execution file is a C or Pro*C program.
Immediate:The execution file is a program written to run as a subroutine of the concurrent manager. We recommend against defining new immediate concurrent programs, and suggest you use either a PL/SQL Stored Procedure or a Spawned C
Program instead.
Request Set Stage Function:PL/SQL Stored Function that can be uesd to
calculate the completion statuses of request set stages.
Explain the steps involved in defining a Custom Key Flexfield .
A)i) register your tables in aol(application object libary).
ii)register your key_flex table table_type as special keyflex.
iii)give the unique id column (ccid),structure column(stid).save it
iv)give the code for flexfield kfx and dynamic insert feasible yes
v)register all the primary key key columns (ccid)
vi)register your foreign key field (ccid)
vii)create a form based on the custom table (kfemp)
viii)put all the (ccid and stid )columns in the null canvas
ix)add two non base table columns as (kfdescription >>text_item and description>display item)
x)write the handlers kfdescription >>> when-new-item-instance
fnd_flex.event('when-new-item-instance');
fnd_flex.event('key-edit');




How do you enable an existing Descriptive flexfield?
In the apps default menu go to Help->Diagnosis->Examine
Then go to Application developer responsibility
FlexFields>Dscriptive>Segments ,Unfreeze the specific Dff and add the required Attributes and Freeze the DFF.

List out the plls and object groups names attached to a Template form and explain about them.
PLLs:
1)APPCORE:
2)APPCORE2: APPCORE and APPCORE2 contain the packages and procedures
that are required of all forms to support the menu, Toolbar, and other required standard behaviors. APPCORE2 is a near–duplicate of APPCORE intended for use with the CUSTOM library.
3)APPDAYPK: contains the packages that control the Applications
Calendar.
4)FNDSQF: contains packages and procedures for Message Dictionary, flexfields, profiles, and concurrent processing. It also has various other utilities for navigation, multicurrency, WHO, etc.
5)VERT:
6)GLOBE:
7)PSAC:
8)PQH_GEN:
9)GHR:
10)JA:
11)JE:
12)JL:
VERT, GLOBE, PSAC, PQH_GEN, GHR, JA, JE, and JL exist to
support globalization and vertical markets. These libraries are for Oracle Applications use only and may not be attached to custom forms. However, they appear to be attached to most forms based on the TEMPLATE form because they are attached to the APPCORE library or other standard libraries.
13)PSA
14)PSB
15)IGIUTIL
16)IGIUTIL2
17)CUSTOM
18)GMS
19)FV
20)OPM
OBJECT GROUPS:
1.STANDARD_PC_AND_VA
2.STANDARD_TOOLBAR
3.STANDARD_CALENDAR
How do we enable who columns in a form?
A) I n the PRE_INSERT and PRE_UPDATE
FND.SET_WHO
How do we attach a calender to a text item of non date datatype?
A)
Under which directory in the server the trace file is created when you on the Trace?

How do you hide the PL/SQL source code of a procedure?

Explain about PL/SQL Wrapper and steps.

Expalin about the Incompatabilites option in Concurrent à Programà Define window.

What is the profile option name used for setting up Audit?
A) Sign -On:Audit Level
What is the procedure used in apps in place of call_form and what are its compulsory arguments ?
A) FND_FUNCTION.EXECUTE(function_name,open_flag,session_flag,other_params,activate)
21. What is the difference between a request set and a request group?
A request SET is a logical grouping of concurrent requests into one set, so they can all
be run at once by submitting one request. It is mostly used for convenience, so that requests
that are commonly run together can be submitted together.
Request sets can be created by any user that has access to the Define Request Set form.
A request GROUP groups together all the requests that can be run by a particular responsibility.
It does not mean that they are all run together, it limits the requests that a user possibly can run.
Request groups are administered by the sysadmin user, using
Security->Responsibility->Request.
22.Can I submit a report set programmatically?
There is a new package for 11i called FND_SUBMIT that contains the request set submission API.
For Release 11.0, you can get the package from patch 914123 or the latest FND patchset.





1) All libraries should reside in the $AU_TOP/resource directory (or its
equivalent).
2) Attaching Libraries
By Oracle Applications standards, library names must be in all uppercase letters (except for the file extension).
Note that your attachment should never include a directory path; your FORMS60_PATH should include the directory that holds all your libraries.
3) Standard Development Environment
• Oracle Forms Developer 6i
• Oracle Reports Developer 6i
• Oracle Application Object Library Release 11i
• Oracle8i
• JInitiator
4) the file OracleApplications.dat must contain the
following lines:
app.ui.requiredFieldVABGColor=255,242,203
app.ui.lovButtons=true
app.ui.requiredFieldVA=true
There are several variables that must be set correctly, either as Unix
environment variables or NT Registry settings, before starting up your
Forms Server for running Oracle Applications. These variables include
NLS_DATE_FORMAT. NLS_DATE_FORMAT must be set to
DD–MON–RR.
5) Mandatory Settings for Form Generation
At form generation time, make sure you designate the character set designed for your language in the NLS_LANG variable in your Windows NT registry or environment file (for Unix).
You must also set the value of your FORMS60_PATH environment variable in your environment file (or platform equivalent such as Windows NT registry) to include any directory that contains forms,files, or libraries you use to develop and generate your forms.Specifically, you must include a path to the <$AU_TOP>/forms/US directory to be able to find all referenced forms, and a path to the <$AU_TOP>/resource directory to be able to find the Oracle Applications library files you need (where <$AU_TOP> is the
appropriate directory path, not the variable).

Set the environment variable (Registry setting) ORACLE_APPLICATIONS to
TRUE before starting Oracle Forms Developer.
6) APPSTAND Form
The APPSTAND form contains the master copy of the shared objects.
It contains the following:
• Object group STANDARD_PC_AND_VA, which contains the Visual Attributes and Property Classes required to implement much of the user interface described in the Oracle Applications •Object group STANDARD_TOOLBAR, which contains the
windows, canvasses, blocks, and items of the Applications Toolbar.
• Object group STANDARD_CALENDAR, which contains the windows, canvasses, blocks, and items of the Applications Calendar.
• Object group QUERY_FIND, which contains a window, canvas,block, and items used as a starting point for coding a FindWindow. This object group is copied into each form, rather thanreferenced, so that it can be modified.



7) Tracking Data Changes with Record History (WHO)
The Record History (WHO) feature reports information about who created or updated rows in Oracle Applications tables. Oracle Applications upgrade technology relies on Record History (WHO) information to detect and preserve customizations.
Call FND_STANDARD.SET_WHO in PRE–UPDATE and
PRE–INSERT to populate these fields.

CREATED_BY ----------> FND_USER
CREATION_DATE
LAST_UPDATED_BY --------->FND_USER
LAST_UPDATE_DATE
LAST_UPDATE_LOGIN ---------à FND_LOGINS
REQUEST_ID ---------à FND_CONCURRENT_REQUESTS
PROGRAM_APPLICATION_ID --------------à FND_CONCURRENT_ PROGRAMS
PROGRAM_ID ----------------à FND_CONCURRENT_ PROGRAMS
PROGRAM_UPDATE_DATE ------------à PROGRAM_UPDATE_DATE

8) LONG, LONG RAW and RAW Datatypes
Avoid creating tables with the LONG, LONG RAW, or RAW datatypes.
Within Oracle Forms, you cannot search using wildcards on any column of these types. Use VARCHAR2(2000) columns instead.
9) Do not use the CHR() function (used to define a character by its ASCII number) on the server side. This causes problems with server–side platforms that use EBCDIC, such as MVS.
10) use FND_MESSAGE to display an error message, then RAISE FORM_TRIGGER_FAILURE to stop processing:

fnd_message.set_name(appl_short_name,
message_name);
fnd_message.error;
RAISE FORM_TRIGGER_FAILURE;
END IF;

11) Errors in Stored Procedures
If a failure occurs in a stored procedure and you want to stop further
processing, use the package procedures FND_MESSAGE.SET_NAME
to set a message, and APP_EXCEPTION.RAISE_EXCEPTION to stop
processing:
IF (error_condition) THEN
fnd_message.set_name(appl_short_name,
message_name);
APP_EXCEPTION.RAISE_EXCEPTION;
END IF;
12)

Related Articles to Read