1. What are the steps in attaching reports
with oracle applications?
- There
are certain steps that you need to follow systematically for attaching the
reports along with oracle application.
- Designing
the report.
- Generating
executable file related with report.
- Moving
executable and source files to the appropriate folder of the product.
- Registering
the report in the form of concurrent executable.
- Defining
concurrent program for registered that are executable.
- Adding
concurrent program for requesting group of responsibility.
2. Differentiate Apps schema from other
schemas?
Apps schema is the one that comprises of only synonyms and
there is no possibility of creating tables in it. Other schema comprises of
tables and objects in it and allows the creation of tables as well as for
providing grants to tables.
3. Define custom top and its purpose.
Custom top can be defined as the customer top which is
created exclusively for customers. According to the requirement of the client
many number of customer tops can be made. Custom top is made used for the
purpose of storing components, which are developed as well as customized. At
the time when the oracle corporation applies patches, every module other than
custom top are overridden.
4. What is the method of calling standard –
interface program from pl/sql or sql code?
FND_REQUEST.SUBMIT_REQUEST(PO, EXECUTABLE
NAME,,,,,PARAMETERS)
5. What is the significance related with US
folder?
US folder is just a language specification. Multiple folders
can be kept for language specification depending on the languages that are
installed.
6. Which are the kinds of report triggers?
There are mainly five different kinds of report triggers
available. They are
- Before
report
- After
report
- Before
parameter form
- After
parameter form
- Between
pages
7. What is the firing sequence related with
report triggers?
The sequence related with firing is as follows before
parameter form, after parameter form, before the report, between pages and
after report.
8. What is the purpose of cursors in PL/SQL?
The cursor can be made used for the purpose of handling
various row – query associated with PL/SQL. Implicit cursors are available for
the purpose of handling all the queries related with oracle. The memory spaces
that are unnamed are used by oracle for storing the data that can be used with
implicit cursors.
9. Define record group?
Record group can be considered as a concept used for the
purpose of holding sql query that is associated with list related with values.
Record group consists of static data and also can access data inside tables of
database through sql queries.
10. What is a FlexField?
This is a kind of field associated with oracle apps that are
used for capturing information related with the organization.
11. Is there any possibility for having custom
schema at any time when it is required?
You have the provision for having custom schema at the time
of creating table.
12. What is the concurrent program?
Concurrent programs are instances that need to be executed
along with incompatibles and parameters.
13. Define application top?
Application tops are found when we are connecting to server.
There are two types of application tops available they are product top and
custom top. Product top is the kind of top that is built in default by
manufacturer. Custom top can be chosen by the client, and any number of custom
tops can be created as per the requirement of the client.
14. Explain about the procedures that are
compulsory in the case of procedures?
There are number of parameters which are mandatory in the
case of procedures and each of these parameters has a specific job associated
with it.
- Errorbuf:
This is the parameter used for returning error messages and for sending
that to log file.
- Retcode:
This is the parameter capable of showing the status associated with a
procedure. 0, 1 and 2 are the status displayed by this parameter. 0 is
used for indicating completed normal status, 1 defines completed warning
status and 2 is the one denoting completed with error.
15. What is a token?
Token is used for transferring values towards report
builder. Tokens are usually not case – sensitive.
16. What is the menu?
Menu can be defined as a hierarchical arrangement associated
with functions of the system.
17. What is Function?
Function is the smaller part of the application and that is
defined inside menu.
18. Define SQL Loader ?
Sql loader is a utility resembling a bulk loader for the
purpose of moving data that are present in external files towards the oracle
database.
19. How to register concurrent program with
oracle apps?
There are certain steps that you need to follow for the
purpose of registering concurrent program.
- The
first step is to log in to your system with the responsibility of the
system administrator.
- The
next step is to define executable concurrent program.
- While
defining concurrent program do take care to give application name, short
name and description along with the selection of executable concurrent
program.
20. Define set – of books?
SOB can be defined as the collection of charts associated
with accounts, currency and calendars.
21. What is a value set?
Value set is used for the purpose of containing the values.
In the case of a value set getting associated with report parameters, a list
containing values are sent to the user for accepting one among the values in
the form of parameter values.
22. Define the Types of validation?
There are various kinds of validation.
- None:
this is the indication of minimal validation.
- Independent:
Input should be there in the list of – values that are defined previously.
- Dependent:
According to the previous value, input is compared with a subset of
values.
- Table:
Input is checked on the basis of values that exist in the application
table.
- Special:
These are the values that make use of flex field.
- Pair:
A pair can be defined as the set of values that make use of flex fields.
- Translated
Independent: This is a kind of value that can be made used only if there
is any existence for the input in the list that is defined previously.
- Translatable
dependent: In this kind of validation rules that compare the input with
the subset of values associated with the previously defined list.
23. Define Template?
Template is a kind of form that is very much required before
the creation of any other type of forms. It is a kind of form that incorporates
attachments that are platform independent and associated with a particular
library.
24. Which are the attachments that are
platform independent and become a part of the template?
There are several attachments that are part of the template
form.
- APPSCORE:
This is a kind of attachment that comprises of packages as well as
procedures which are useful for all the different forms for the purpose of
creating toolbars, menus etc.
- APPSDAYPK:
This attachment contains packages that are helpful in controlling the
applications associated with oracle.
- FNDSQF:
This attachment has various procedures as well as packages for flex
fields, profiles, message dictionary and also concurrent processing.
- CUSTOM:
This attachment is helpful in extending the application forms of oracle
without causing any modification related with the application code. There
are various kinds of customization including zoom.
25. Define Ad-hoc reports?
This is a kind of report that is made used for fulfilling
the reporting needs of a particular time.
26. What is the Definition of responsibility?
Responsibility is the method through which the group of
various modules can be made in a format accessible by users.
27. Define Autonomous transaction?
This is a kind of transaction that is independent of another
transaction. This kind of transaction allows you in suspending the main
transaction and helps in performing SQL operations, rolling back of operations
and also committing them. The autonomous transactions do not support resources,
locks or any kind of commit dependencies that are part of main transaction.
28. Which are the types of Triggers?
There are various kinds of triggers associated with forms
and they are
- Key
triggers
- Error
triggers
- Message
triggers
- Navigational
triggers
- Query
– based triggers
- Transactional
triggers
29. What is the purpose of Temp tables in
interface programs?
These are the kinds of tables that can be used for the
purpose of storing intermediate values or data.
30. Where to define the parameters in the
report?
The parameters can be defined inside the form of concurrent
program, and there is no need for registering the parameters but you may need
to register the set of values that are associated with the parameters.
31. Define the steps for customizing form?
You need to make use of the following steps for the purpose
of customizing forms.
- The
first and foremost thing that you need to do is to copy the files
template.fmb as well as Appsatnd.fmb from AU_TOP/forms/us and paste that
inside custom directory. By doing this the library associated with this
task get copied by it’s own.
- You
can now create the forms you want and customize them.
- Do
not forget to save the created forms inside the modules where they need to
be located.
32. Define about Key Flexfiled ?
Key flexfiled is a unique identifier and is usually stored
inside segment, and there are two different attributes associated with this
which are flexfiled qualifier and segment qualifier.
32. Define uses of Key Flexfield ?
This is a unique identifier for the purpose of storing
information related with key. It also helps in entering as well as displaying
information related with key.
34. Define Descriptive FlexField ?
This is a kind of flexfield that is mainly used for the
purpose of capturing additional information, and it is stored in the form of
attributes. Descriptive flexfield is context sensitive.
35. List some uses of DFF (Descriptive Flex
Field) ?
This is a kind of flexfield that is mainly used for
gathering extra information and also for providing space for you to form and
get expanded.
36. Define MRC ( Multiple Reporting Currency)?
Multiple – Reporting Currency is a kind of feature that is
associated with oracle application and helps in reporting as well as
maintaining records that are associated with the transaction level in various
forms of functional currency.
37. Define FSG ( Financial Statement
Generator) ?
This is a kind of tool that is highly powerful as well as
flexible and helps in building reports that are customized without depending on
programming. This tool is only available with GL.
38. Define Oracle Suite?
Oracle suite is the one that comprises of oracle apps as
well as software associated with analytical components.
39. Define ERP (Enterprise Resource Planning)
?
ERP is a software system that is available as a package and
can be helpful in automating as well as integrating most of the processes
associated with the business.
40. What is a datalink?
Datalink can be made used for the purpose of relating the
results that are associated with various different queries.
41. How to attain parameter value depending on
the first parameter?
Second parameter can be attained by making use of the first
parameter by making use of the command $flex$value set name.
42. Define data group?
Data group can be defined as the group of applications
related with oracle.
43. Explain about security attributes?
Security attributes can be made used by Oracle for allowing
the particular rows containing data visible to the users.
44. Define about Profile Option?
Profile option comprises of set of options that are helpful
in defining the appearance as well as behavior of the application.
45. Explain about application?
Application can be defined as the set of menus, forms and
functions.
46. Where do we use Custom.pll?
Custom.pll can be used during the process of making
customized or new oracle forms.
47. Where are tables created?
Tables can be created at custom schema.
48. Define multi org ?
This is a kind of functionality for data security.
49. Define Request Group ?
Request group is assigned with a set of responsibilities.
50. What is the usage of the spawned object?
This object is used for process associated with executable
field.
Hope you enjoyed, this list of frequently asked Oracle Apps
Technical Interview Questions
Q. What
is purpose of applsyspub user in Oracle EBS?
APPLSYSPUB is an initial,
pre-authentication user with minimal privileges to assist with APPS (FND) user
authentication. Usernames and passwords are stored in the FND_USER table, we
need to have a pre-connection to the database. This connection is established
using APPLSYSPUB user. After successfull login, associated database login will
switch to APPS user from APPLSYSPUB user. APPLSYSPUB has only Read-Only
privileges on a few tables and views for signing on to Applications.
Q. What
is purpose of Applications Listener in Oracle EBS?
During concurrent managers
startup ICM instructs Applications Listener to spawn FNDSM (Service manager)
process.
You can confirm this by
checking listener.ora configuration file on apps tier, which is located under
directory $ORACLE_HOME/network/admin:
SID_LIST_APPS_PROD =
(SID_LIST =
(
SID_DESC = ( SID_NAME = FNDSM )
(
ORACLE_HOME = /u01/app/apps/fs1/EBSapps/10.1.2 )
(
PROGRAM = /u01/app/apps/fs1/EBSapps/appl/fnd/12.0.0/bin/FNDSM )
(
envs=’MYAPPSORA=/u01/app/apps/fs1/EBSapps/appl/APPSPROD_tvmdb19.env,PATH=/usr/bin:/usr/ccs/bin:/bin,FNDSM_SCRIPT=/u01/app/apps/fs1/inst/apps/PROD_tvmdb19/admin/scripts/gsmstart.sh’
)
Q. Is
it possible to run two adpatch sessions simultaneously for one EBS instance?
It’s possible to run
several adpatch sessions, but they will eventually fail. At different stages of
work you may get different errors. One of them related to FND_INSTALL_PROCESSES
table which is created to keep track of what jobs adpatch workers are doing.
Sample error message:
The table
FND_INSTALL_PROCESSES created by AutoPatch already exists.
If you are sure you do not
want to keep the information from the failed
AutoPatch session,you may
drop FND_INSTALL_PROCESSES table and continue with
AutoPatch.
If you choose not to drop
FND_INSTALL_PROCESSES table, AutoPatch cannot continue successfully.
Q. What
is procedure of patching in case of multi-node EBS installation and non-shared
application tier?
In this case you have to
apply patches on every application node. Also the answer depends on EBS release
number. If it’s 11i, then you have to start patching from node where
administration server is located. Reason for that – adpatch runs database
part of unified driver only on node where administration server is located.
Release R12 eliminated need
for DBAs to pay attention at patching sequence. Here is quote from R12
concepts: “There is no concept of an Administration server in Release 12. By
default, patching can be undertaken from any application tier node.”
Q. Is
it required to run autoconfig on all nodes in case of Shared Application Tier
multi-node installation?
Yes. All configuration
files created by AutoConfig are stored under the Instance Home. So to update
all Instance Homes it’s required to run autoconfig on each node.
Q. Does
ICM (Internal concurrent manager) processes concurrent requests?
It does, but only specific
ones. ICM controls other concurrent managers and executes queue control
requests, such as ACTIVATE, DEACTIVATE, or ABORT
Q. If
ICM is terminated abnormally (for example killed), will other managers continue
to process requests?
Yes, other managers will
continue to perform their usual work. However it doesn’t apply to the case when
you stop ICM using Administer concurrent managers form. In this case, other
managers will be shut down.
Q. What
is the Directory structure on the server ?
SERVER – SIDE DIRECTORY
TREE TO STORE FILES
Application Directory
bin sql log srw mesg
lib rpt forms out plsql
( lang )
- Bin : Contains executable code of your concurrent programs
written in a programming language such as C, Pro*C, Fortran, or an
operating system script.
- Lib : Contains compiled object code of your concurrent programs.
- Sql : Contains concurrent programs written in SQL*Plus and
PL/SQL scripts.
- Rpt : Contains concurrent programs written with SQL*Reports.
- Log : Contains log files from concurrent programs.
- Forms/(Language) : Each language has a subdirectory ( such as
US ). The language subdirectory holds the forms .fmx files.
- Srw : Contains concurrent programs written with Oracle
Reports.
- Out : Contains output files from concurrent program.
- Mesg : Holds your application message files for Message
dictionary.
- PLSQL : Contains PL/SQL libraries used with Oracle reports.
Q. What are the salient
features of Aol and Sysadmin functions?
APPLICATION OBJECT LIBRARY
As evident from the name
AOL i.e. Application Object Library is the Library that contains all the
Objects of an Application. For Oracle Apps. To recognize any object, such
object must be registered with this Library.
Salient Features –
- Registering Tables with Oracle Apps.
- Registering Forms with Oracle Apps.
- Registering Concurrent Programs with Oracle Apps.
- Building Menus.
- Building Flexfields.
- Enabling Zoom.
- Building Message Dictionary.
SYSTEM ADMINISTRATION
- Manage Oracle Applications security.
- Manage Concurrent programs & Reports.
- Manage Concurrent processing.
- Manage Printers.
- Manage Profile Options.
- Manage Document Sequences.
Q. How do you create a
customized form in Apps?
TEMPLATE FORM
You will find it in
c:\Apps10\Fnd75\Forms\Us
Features –
Starting your form with TEMPLATE is the only way
to ensure you get the following:
a) Applications Property Classes and Visual
Attributes.
b) Toolbar.
c) Menu.
d) Calendar.
e) Required Form-Level triggers.
f) Required Procedures.
g) Applications color palatte.
h) Required Parameters.
i) Required LOVs and Record Groups.
j) And much more !
Q. Which Pl/Sql libraries
are used in customization of form and for what purpose ?
Attached Libraries Used in forms development –
a) APPCORE – Supports Form and User Interface
Features.
Packages and Procedures that support the menu,
Toolbar and other standard behaviours.
Use APPCORE routines to enable fields to enable
fields dynamically, maintain dependencies between items, and control specific
window behaviours.
b) GLOBE
c) FNDSQF – Supports Many Application Object
Library Features.
Most AOL extensions such as message dictionary,
multicurrency, WHO information tracking.
Includes Flexfield packages and procedures.
d) JA
e) JL
f) JE
g) CUSTOM – Supports Zoom.
h) APPDAYPK – Supports the Calendar.
Q. What is ZOOM ?
ENABLING ZOOM
In certain cases, it is
useful to be able to access one form directly from another. For example, it may
be very convenient to be able to open the Customers form directly from the
Sales Orders form, to allow entry of a new customer while creating a new order,
or to view information about a customer that has already been defined. From
within certain forms you can open another form directly by using the Special
menu or, depending on how Oracle Applications has been customized at your site,
by choosing Zoom from the Go menu.
Oracle Applications ship
with no Zooms defined, and the Zoom entry on the Action menu is disabled. When
this feature is available and how it behaves are determined by how Oracle
Applications is customized at your site.
Zoom allows the addition of
user-invoked logic on a per-block basis.
How do you register tables in Apps ? What is the PL/SQl package
used for registering ?
REGISTERING TABLES WITH
ORACLE APPLICATIONS
With Release 10.6 and 10.7,
you now register your custom application tables using a PL/SQL routine in the
AD_DD package.
Procedures in the AD_DD
Package
procedure register_table
(p_appl_short_name in varchar2,
p_tab_name in varchar2,
p_tab_type in varchar2,
p_next_extent in number
default 512,
p_pct_free in number
default 10,
p_pct_used in number
default 70);
procedure register_column (p_appl_short_name
in varchar2,
p_tab_name in varchar2,
p_col_name in varchar2,
p_col_seq in number,
p_col_type in varchar2,
p_col_width in number,
p_nullable in varchar2,
p_translate in varchar2,
p_precision in number
default null,
p_scale in number default
null);
procedure delete_table
(p_appl_short_name in varchar2,
p_tab_name in varchar2);
procedure delete_column
(p_appl_short_name in varchar2,
p_tab_name in varchar2,
p_col_name in varchar2);
p_appl_short_name The
application short name of the application that owns the table (usually your
custom application).
p_tab_name The name of the
table (in uppercase letters).
p_tab_type Use ‘T’ if it is
a transaction table (almost all application tables), or ‘S’ for a “seed data”
table (used only by Oracle Applications products).
p_pct_free The percentage
of space in each of the table’s blocks reserved for future updates to the table
(1-99). The sum of p_pct_free and p_pct_used must be less than 100.
p_pct_used Minimum
percentage of used space in each data block of the table (1-99). The sum of
p_pct_free and p_pct_used must be less than 100.
p_col_name The name of the
column (in uppercase letters).
p_col_seq The sequence
number of the column in the table (the order in which the column appears in the
table definition).
p_col_type The column type
(‘NUMBER’, ‘VARCHAR2′, ‘DATE’, etc.).
p_col_width The column size
(a number). Use 9 for DATE columns, 38 for NUMBER columns (unless it has a
specific width).
p_nullable Use ‘N’ if the
column is mandatory or ‘Y’ if the column allows null values.
p_translate Use ‘Y’ if the
column values will be translated for an Oracle Applications product release
(used only by Oracle Applications products) or ‘N’ if the values are not
translated (most application columns).
p_next_extent The next
extent size, in kilobytes. Do not include the ‘K’.
p_precision The total
number of digits in a number.
p_scale The number of
digits to the right of the decimal point in a number.
No comments:
Post a Comment