Oracle Applications Technical Interview Questions
Oracle Applications Technical Interview Questions
Q. What is SET-OF-BOOKS?
Collection of Chat of Accounts and Currency and Calendars is called SO
Q. How can u call a standard interface program from sql or pl/sql code?
FND_REQUEST.SUBMIT_REQUEST („PO‟,‟EXECUTABLE NAME‟,,,,PARAMETERS)
Q. API‟s FOR CUSTOMER INTERFACE?
FND_CONCSUB(can submit conc program in host environment)
Q. PL/SQL stored procedure parameters? or what are the two parameters that are mandatory for pl/sql type concurrent program?
Procedure/function (ERRBUF OUT RETCODE OUT ………………….)
ERRBUF :- Used to write the error message to log or request file.
RETCODE :- Populate log request file with program submission details info.
Q. What is Value Set?
- The value set is a collection (or) container of values.
- When ever the value set associated with any report parameters. It provides list of values to the end user to accept one of the values as report parameter value.
- If the list of values needed to be dynamic and ever changing and define a table based values set.
Q. What r the validation types?
1) None ——– validation is minimal.
2) Independent ——input must exist on previously defined list of values
3) Dependent ——input is checked against a subset of values based on a prior value.
3) Table —– input is checked against values in an application table
4) Special ——values set uses a flex field itself.
5) Pair —— two flex fields together specify a range of valid values.
6) Translatable independent —– input must exist on previously defined list
of values; translated values can be used.
7) Translatable dependent ——- input is checked against a subset of values
based on a prior values; translated value can be used.
Q. What is template?
a) The TEMPLATE form is the required starting point for all development of new Forms.
b) The TEMPLATE form includes platform–independent attachments of several Libraries.
APPSCORE :- It contains package and procedures that are required of all forms to support the MENUS ,TOOLBARS.
APPSDAYPK :- It contains packages that control the oracle applications CALENDER FEATURES.
FNDSQF :- it contains packages and procedures for MESSAGE DICTONARY, FLEX FIELDS, PROFILES AND CONCURRENT PROCESSING.
CUSTOM :- it allows extension of oracle applications forms with out modification of oracle application code, you can use the custom library for customization such as zoom ( such as moving to another form and querying up specific records)
Q. What are ad-hoc reports?
Ad-hoc Report is made to meet one-time reporting needs. Concerned with or formed for a particular purpose. For example, ad hoc tax codes or an ad hoc database query
Q. What is responsibility?
Is collection of menus, request security groups and data groups
Menus: collection of forms is nothing but menus
Request security groups: collection of programs.
Data groups: is a group of modules to be made accessible by the user through Responsibility
Q. Oracle E-Business suite?
Oracle apps + analytical components software.
(Oracle discover) (Oracle sales analyzer) (Oracle financial analyzer) (Oracle marketing analyzer)
Q. What is multi org?
“Legal entity has more than one operating unit is called as multi org”
- Business group — Human resources information is secured by Business group
- Legal entity. — inter-company and fiscal/tax reporting.
- Operating unit — secures AR, OE, AP, PA and PO Information.
- Organizations — is a specialize unit of work at particular locations
Q. What is ERP? Architecture of apps?
A packaged business software system that lets a company automate and integrate the majority of its business processes; share common data and practices across the enterprise; [and] produce and access information in a real-time environment.
Q. Data Link
- Data links relate the results of multiple queries.
- A data link (Parent – Child Relation Ship) causes the child query to be executed once for each instance of its parent group.
Q. In which tables FF are stored?
- FND – ID – FLEXS
- FND-ID-FLEX-STRUCTURES 5
Q. Oracle Applications Architecture
Internet computing Architecture is a frame work for 3-tired, distributed computing that supports Oracle Applications products.
The Three tiers are
- Data Base Tier
- Application Tier
- Desk Top Tier
– Database tier manages Oracle 8i database.
– Application tier manages Oracle Applications and other tools.
– Desktop tier provides the user interface displace.
– With internet computing architecture, only the presentation layer of Oracle Applications is on the Desk Top tier in the form of a plug-in to a standard internet brows
Q. List of some API‟S
Q. How to get second parameter value based on first parameter?
$fle x $ value setname.
Q. How to call WHO columns into the form
By using FND_STANDARD API‟S
Provides information about the form.
Should be called form when_new_form – instance – instance trigger.
loads WHO columns with proper user information.
Should be called from PRE_UPDTE and PRE_INSERT
Triggers for each block with WHO fields
If this is used FND-GLOBAL need not be called. (FND_GLOBAL.WHO)
This is a function which returns date.
Behave exactly like SYSDATE built-in.
This is a function which returns varchar2
Behaves exactly like built in USER.
Q. APPCORE API‟S
- APP_REGION 7
Q. FNDSQF API‟S
- FND_UTILITIES. PARAM_EXISTS
Q. How to register a table and columns through back end?
- by using AD_DD package for registering a table
- AD_DD BPI doesn‟t check for the existence of the registered table or column in the data base schema, but only updates the required SQL tables.
- It should be ensured that, all the tables and columns registered exist actually and have the same format as that defined using AD_DD API.
- Views need not be registered.
Q. Function FND_REQUEST.SUBMIT_REQUEST
( application in varchar2 default null,
program in varchar2 default null,
description in varchar2 default null,
start-time in varchar2 default null,
sub_request in bookan default False,
argument 100) return number;
- If this is submitted from oracle forms, all the arguments ( 1 to 100 ) must be specified.
Q. What is the reason for not getting any data when a multi org view is quired?
- to get the data correctly, the xxx-ALL must be referenced and the ORG_ID value should be specified to extract portioned data.
- Multiorg views are partitioned by using ORG_ID.
- So access through multiorg views will not return any roes, as the CLIENT_INFO Value is not set
- Use HR_OPERATING UNITS to identify the organization _id of the OU on which query is based.
- Use FND_CLIENT_INFO package to set the value in CLIENT INPO using set_org_contest.
- Execute fnd_client_info. Set_org_context („<org_id>‟);
- Now qurying of multiorg views can be done.
Q. How do you find that muliorg is installed?
- multi organization architecture is meant to allow muliple companies or subsidiaries to store their records with in a single data base.
- Multiple organization Architecture allows this by partitioning data through views in APPS schema.
- Implementation of Multi org generally includes more than one business group.
To know whether multiorg is existing or not
- if the result is „Y‟ means the database is group for multiorg
Q. What are Handlers?
Handler is a group of packaged procedures which is used by Oracle Applications to organize . PL/SQL code in forms.
- Handlers provide a way to centralize the code so that it becomes easier to develop, maintain and debug.
- The packaged procedures available in a handler are called form the triggers by passing the name of the trigger as an argument for the procedure to process.
Handlers are types :-
1) Item Handlers
2) Event Handlers
3) Table Handlers
4) Business Rules
- Handlers reside in program units in the form or in stored packed in the database.
Q. What is a Data Group?
- A data group is a group of oracle applications and the Oracle ID‟s of each application
- Oracle ID grants access privileges to tables in an Oracle Database
- Data group determines which Oracle Data base accounts a responsibilities forms, concurrent programs and reports connect to.
Q. What is a Responsibility?
- Responsibility defines Applications Privileges
- A responsibility is a level of authority in Oracle Applications that lets users only those Oracle Applications functions and data appropriate to their roles in an organization.
- Each user has at list one or more responsibilities and several users can share the same responsibility 22
Each responsibility allows access to
- a specific application or a set of applications.
- A set of books
- A restricted list of windows that an user can navigate
- Reports in a specific application.
Q. What are security Attributes?
Security Attributes are used by Oracle self service web Applications to allow rows of data to be visible to specified users responsibilities based on the specific data contained in the row.
Q. What is a Profile Option?
- Profile options are the set of changeable options that affects how the application looks and behaves.
- By setting profile options, the applications can be made to react in different ways for different users depending on the specific user attributes.
Q. What are steps involved in developing a flex field?
- designing the table structure
- creating fields on the form (Visible/Hidden)
- calling appropriate routines
- registration of the flex field.
- Definition of the flex field.
<Flex fields / key/ Register>
<Flex fields/Descriptions / Register>
Q. What is an application /Module?
Application is a collection of forms, function and menus
Q. What are the types of Concurrent Managers 25
3 MASTER CONCURRENT MANAGERS:
- Internal Conccurent Manager (ICM): This is the one which monitors all other CMs
- Standard Manager (SM) : This takes care of report running and batch jobs
- Conflict Resolution Manager (CRM): checks concurrent program definitions for incompatability checks.
We cannot delete a concurrent manager… but we can disable it… but it’s not recommended.
Q. multi org set up
Q. What is the relation between Responsibility, Menu and Request Group?
Responsibility: – A responsibility is a set of authority in Oracle Apps that lets users access only that functionality of the application appropriate to their roles.
Menu: – A menu is a hierarchical arrangement of functions and menus of functions that appears in the Navigator. Each responsibility has a menu assigned to it.
Request Group: – it is a collection of reports or concurrent programs. A system Administrator defines report groups in order to control user access to reports and concurrent programs. Only a system administrator can create a request group.
Q. What is a function, how to create one?
A function is apart of an application‟s functionality that is registered under a unique name for the purpose of assigning to it to, or excluding it from, a menu (and by extension, responsibility). There are several types of functions: – Form Functions, SubFunctions, and
Non-form functions. We often refer to a form function simply as a form.
Q. What is meant by APPL_TOP?
An operating System variable that describes an aspect of the environment in which your application runs. For example, you can define an environment variable to specify a directory path. 26
$APPL_TOP: An environment variable that denotes the installation directory for Oracle Application Object Library and your other Oracle applications. $APPL_TOP is usually one directory level above each of the product directories (which are often referred to as $PROD_TOP or $PRODUCT_TOP or $<prod>_TOP).
Q. Explain briefly where are the Custom.pll, Forms, Reports, Sql Loader Control files, Shell Script source code and executables files kept?
Custom.pll – $AU_TOP/resource
Forms – $PROD_TOP/Forms/US
Reports – $PROD_TOP/Reports/US
SQL Control Files – $PROD_TOP/Bin
Shell Scripts – $PROD_TOP/Bin
Q. When is Custom.pll used?
Custom.pll is used while making new or customizing standard oraclke forms in apps. It contains all the forms libraries for apps.
Q. What are profile options; at what levels can these be set?
A user profile is a set of changeable options that affects the way the applications run. Oracle
Applications object Library establishes a value for each option in a user‟s profile when the
User logs on or changes responsibility.
System Profile: – Profile option can be set for the user community.
User Profile: – Provide Oracle Apps with standard information which describes a user,
Application, Responsibility and site. At each profile level user profile options can be set.
Q. How can you know the form (fmb) name when you open a form in Apps?
Q. Where do you create a table and sequence in Apps? Is it APPS schema?
In custom schema and then grant privileges on it to APPS schema.
Q. Where are Views and Procedures created?
Views: – Views are to be created only in APPS.
Procedures: – In custom schema and the grant it to APPS schema.
Q. Can new profiles be created? If so how?
Yes. Application Developer.
Q. What is the approach to create a new form to be used in Oracle Apps?
The TEMPLATE form is the required starting point of all development of new forms. Start
Developing each new form by copying the TEMPLATE.fmb file, located in
$AU_TOP/forms/US(or your language and platform equivalent), to local directory and
Rename it as appropriate.
Q. Explain Value Set? Difference between a Table Validated and Independent Value Set?
A set of values against which Oracle Application Object Library validates values your end users enter when running your program. You define your value set by specifying validation 28 rules, format constraints and other properties. For example, you could define a value set to contain values that are character strings, validated from a table in your application. You can Specify that oracle application Object Library use the same value set to validate different Report parameters. You can also use value sets that you use in your flex fields to validate Your report parameters.
Q. How do you create a table validated value set dependent on another value set?
Use :$FLEX$.<Value set name> in the where condition.
Q. How do you set the operating unit context in a report?
Q. Can you submit a concurrent request from the operating system directly?
Write a Shellscript.
Login to database
Run the function FND_REQUEST.Submit()
Q. Explain how to generate a trace file for a pl/sql concurrent program for tuning?
Check the‟Enable Trace‟ check box in concurrent program registration window.
Q. How do you “write” to the concurrent request Log and Output file?
FND_FILE.PUT(FND_FILE.LOG or FND_FILE.OUTPUT, <Text>);
Q. What is the difference between Operating Unit and Inventory Organization?
Operating Unit :- An Organization that uses Oracle Cash management, Order management and Shipping Execution, Oracle Payables, Oracle Purchasing, and Oracle Receivables. It may be a sales Office, a division, or a dept. An operating unit is associated with a legal entity. Information is secured by operating unit for these applications. Each user sees information only for their operating unit. To run any of these applications, you choose a responsibility associated with an organization classified as an operating unit.
An organization for which you track inventory transactions and balances, and/or an organization that manufactures or distributes products. Examples, include (but are not limited to) manufacturing plants, warehouses, distribution centers, and sales offices. The following applications secure information by inventory organization: Oracle inventory, Bills of Material, Engineering, and Work in Process, Master Scheduling/MRP, Capacity, and Purchasing receiving functions. To run any of these applications, you must choose an organization that has been classified as an inventory organization.
Q. What is Set of Books?
A financial reporting entity that uses a particular chart of accounts, functional currency,
And accounting calendar. Oracle General Ledger secures transaction information (such as journal entries and balances) by set of books. When you use Oracle General Ledger, you choose a responsibility that specifies a set of books. You then see information for that set of books only.
Q. What is Item Validation Organization?
The organization that contains your master list of items. You define it by setting the OM: Item Validation Organization parameter. You must define all items and bills in your Item Validation Organization, but you also need to maintain your items and bills in separate organizations if you want to ship them from other warehouses.
Q. What is the difference between key flexfield and Descriptive flexfield?
Key Flexfield is used to describe unique identifiers that will have a better meaning than using number IDs. e.g a part number, a cost centre etc Desc Flex is used to just capture extra information. Key Flexfields have qualifiers whereas Desc Flexfields do not. Desc Flexfields can have context sensitive segments while Key flexfields cannot.
And one more differenct that KFF displays like text item but DFF displays like [ ] .
Q. Which procedure should be called to enable a DFF in a form?
FND_DESCR_FLEX.DEFINE (BLOCK => ‘BLOCK_NAME’ ,FIELD => ‘FORM_FIELD_NAME’ ,APPL_SHORT_NAME => ‘APP_NAME’ ,DESC_FLEX_NAME => ‘DFF_NAME’ );
Q. Which procedure should be used to make the DFF read only at run time?
Q. What is the difference between flexfield qualifier and segment qualifier?
Flexfiled qualifier identifies segement in a flexfield and segment qualifier identifies value in a segment.
There are four types of flexfiled qualifier
1) Balancing segment qualifier
2) cost center
3) natural account and
segemtn qualifier :-
1) allow budgeting
2) allow posting
3) account type
4) contral account and
5) reconciliation flag
Q. Where do concurrent request logfiles and output files go?
The concurrent manager first looks for the environment variable $APPLCSF If this is set, it creates a path using two other environment variables: $APPLLOG and $APPLOUT It places log files in $APPLCSF/$APPLLOG Output files go in $APPLCSF/$APPLOUT So for example, if you have this environment set: $APPLCSF = /u01/appl/common $APPLLOG = log $APPLOUT = out The concurrent manager will place log files in /u01/appl/common/log, and output files in /u01/appl/common/out Note that $APPLCSF must be a full, absolute path, and the other two are directory names. If $APPLCSF is not set, it places the files under the product top of the application associated with the request. So for example, a PO report would go under $PO_TOP/$APPLLOG and $PO_TOP/$APPLOUT Logfiles go to: /u01/appl/po/9.0/log Output files to: /u01/appl/po/9.0/out Of course, all these directories must exist and have the correct permissions. Note that all concurrent requests produce a log file, but not necessarily an output file.
Q. How do I check if Multi-org is installed?
SELECT MULTI_ORG_FLAG FROM FND_PRODUCT_GROUPS
If MULTI_ORG_FLAG is set to ‘Y’, Then its Multi Org.
Q. Why does Help->Tools->Examine ask for a password?
Navigate to the Update System Profile Screen.
(\ navigate profile system)
- Select Level: Site
- Query up Utilities:Diagnostics in the User Profile Options Zone.
If the profile option Utilities:Diagnostics is set to NO, people with access to the Utilities Menu must enter the password for the ORACLE ID of the current responsibility to use Examine. If set to Yes, a password will not be required.
Q. How an API is initialized ?
( user_id => p_user_id , resp_id => p_resp_id , resp_appl_id => p_resp_appl_id)
Q. How do u register a concurrent program from PL/SQL ?
apps.fnd_program.executable_exists -> To check if executable file exists
apps.fnd_program.executable -> To make executable file
fnd_program.program_exists -> To check if program is defined
apps.fnd_program.register -> To register/define the program
apps.fnd_program.parameter -> To add parameters
apps.fnd_program.request_group -> To add to a request group
Q. How Do u register a table & a column ?
EXECUTE ad_dd.register_table( ‘GEMSQA’, ‘gems_qa_iqa_lookup_codes’, ‘T’, 512, 10, 70);
EXECUTE ad_dd.register_column(‘GEMSQA’, ‘gems_qa_iqa_lookup_codes’, ‘LOOKUP_CODE’, 1, ‘VARCHAR2’, 25, ‘N’, ‘N’);
Q. What are the supported versions of Forms and Reports used for developing on Oracle Applications Release 11?
The following supported versions are provided in Developer/2000
- Forms 4.5
- Reports 2.5
Q. What is Responsibility / Request Group?
Responsibility is used for security reason like which Responsibility can do what type of jobs etc.
Set of Responsibility is attached with a Request group. When we attach the request group to a concurrent program, that can be perform using all the Responsibilities those are attached with Request group.
Q. What is DFF?
The Descriptive Flexi field is a field that we can customize to enter additional information for which Oracle Apps product has not provided a field.
Ex. ATP program calculates for those warehouses where Inventory Org Type is DC or Warehouse in DFF Attribute11 of MTL_PARAMETERS table.
Q. What is multi-org?
It is data security functionality in Oracle 10.6 and above. Applicable User responsibilities are created and attached to specific Operating Unit. User can access the data that belongs to the Operating unit they login under. 40
The benefit is it enables multiple operating units to use a single installation of various modules, while keeping transaction data separate and secure by operating unit.
It has an effect on the following modules:
- Order Entry
- Project Accounting