Oracle APPS Technical interview question for experienced/Oracle APS Technical Interview Questions and Answers for Freshers & Experienced

What are the steps we will follow to register Reports as a Concurrent Program?

First, develop the report & save it in a local machine. upload into custom_top/11.5.0/reports/us/goes to system administrator open executable form create an executable by mentioning executable method as reports, executable as report name which was created. go to the cc program form create a program by attaching executable name in the executable section. then attach this program to request group, Request group to Responsibility. Responsibility to User.

Posted Date:- 2021-10-01 10:34:25

what is Apps Schema and Schema?

Schema: Schema is the location in the database contains database objects like views, tables, and synonyms.

Apps Schema: It is used to connect the all schemas to get the information from the database.

Posted Date:- 2021-10-01 10:33:33

Explain how to handle errors in the Customer interface?

We can handle errors by using SQL*Loader, or another import program, to load customer information into the interface tables.

When you import customer information, the Customer Interface program validates the global attribute columns in the interface tables and transfers those values into the customer tables.

Get through the interview bar with our selected interview questions for Oracle Apps Technical enthusiasts
Tell me something about SQL-LOADER.

Sql * loader is a bulk loader utility used for moving data from external files into the oracle database.

Posted Date:- 2021-10-01 10:32:43

What Are The Three Essential Components Of A Gl Set Of Book?


* Your chart of accounts is the account structure you define to fit the specific needs of your organization.
* You can choose the number of account segments as well as the length, name, and order of each segment.


* An accounting calendar defines an accounting year and the periods it contains.
* You can define multiple calendars and assign a different calendar to each set of books.


* You select the functional currency for your set of books as well as other currencies that you use to transact business and report in.
* GL converts monetary amounts entered in a foreign currency to functional currency equivalents using supplied rates.

Posted Date:- 2021-10-01 10:31:54

What Is The Purpose Of The Transaction Calendar?

The transaction calendar is defined to enable average balance processing. The transaction calendar is created optionally with valid business days mentioned.

Posted Date:- 2021-10-01 10:30:44

To Allow Unbalances Journal Posting What Action Is Required At Set Of Book Definition Level / What Is A Suspense Account And Its Purpose?

If you choose to allow posting of out-of-balance/unbalanced journal entries, GL automatically posts the difference to Suspense Account. However, the Suspense Account checkbox should be checked and an Account to be provided for this feature to work during the creation of a set of books.

Posted Date:- 2021-10-01 10:30:09

Define the 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 numbers of customer tops can be made. The custom top is made used to store components, which are developed as well as customized. At the time when the oracle corporation applies patches, every module other than the custom top is overridden.

Posted Date:- 2021-10-01 10:29:32

How to register a concurrent program with oracle apps?

There are certain steps that you need to follow to register the 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 an executable concurrent program.
While defining concurrent programs do take care to give application name, short name and description along with the selection of executable concurrent program.

Posted Date:- 2021-10-01 10:28:55

What is the significance related to the US folder?

The US folder is just a language specification. Multiple folders can be kept for language specifications depending on the languages that are installed.

Posted Date:- 2021-10-01 10:27:57

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 an executable file related to the report.
* Moving executable and source files to the appropriate folder of the product.
* Registering the report in the form of concurrent executable.
* Defining a concurrent program for registered that is executable.
* Adding a concurrent program for requesting a group of responsibility.

Posted Date:- 2021-10-01 10:27:06

What are INBOUND and OUTBOUND? (Different types of interfaces)

Inbound Interface: For inbound interfaces, where these products are the destination, interface tables as well as supporting validation, processing, and maintenance programs are provided. Outbound Interface: For outbound interfaces, where these products are the source, database views are provided and the destination application should provide the validation, processing, and maintenance programs.

Posted Date:- 2021-10-01 10:25:04

Incompatibility in report registration and Run Alone?

* Identify programs that should not run simultaneously with your concurrent program because they might interfere with its execution.

* You can specify your program as being incompatible with itself.

* Application: Although the default for this field is the application of your concurrent program, you can enter any valid application name.

* Name: The program name and application you specify must uniquely identify a concurrent program. Your list displays the user-friendly name of the program, the short name, and the description of the program.

* Scope: Enter Set or Program Only to specify whether your concurrent program is incompatible with this program and all its child requests (Set) or only with this program (Program Only).

* Run Alone: Indicate whether your program should run alone relative to all other programs in the same logical database. If the execution of your program interferes with the execution of all other programs in the same logical database (in other words, if your program is incompatible with all programs in its logical database, including itself), it should run alone.

Posted Date:- 2021-10-01 10:24:21

Report registration process?

* Create the report using the report builder.
* Place the report definition file in the module-specific reports directory.
* Create an executable for the report definition file.
* Create a concurrent program to that executable.
* Associate the concurrent program to a request group.

Posted Date:- 2021-10-01 10:22:51

What is TCA (Trading Community Architecture)?

Oracle Trading Community Architecture (TCA) is a data model that allows you to manage complex information about the parties, or customers, who belong to your commercial community, including organizations, locations, and the network of hierarchical relationships among them. This information is maintained in the TCA Registry, which is the single source of trading community information for Oracle E-Business Suite applications.

Posted Date:- 2021-10-01 10:21:37

What is the Summary columns?

A summary column performs a computation on another column's data. Using the Report Wizard or Data Wizard, you can create the following summaries: sum, average, count, minimum, maximum, % total. You can also create a summary column manually in the Data Model view, and use the Property Palette to create the following additional summaries: first, last, standard deviation, variance.

Posted Date:- 2021-10-01 10:17:32

What is Formula Column?

A formula column performs a user-defined computation on another column(s) of data, including placeholder columns.

Posted Date:- 2021-10-01 10:17:02

What is Place holder Columns?

A placeholder is a column that is an empty container at design time. The placeholder can hold a value at run time has been calculated and placed into It by pl/sql code from another object.

You can set the value of a placeholder column is in a Before Report trigger.

Store a Temporary value for future reference. EX. Store the current max salary as records are retrieved.

Posted Date:- 2021-10-01 10:15:44

What is Flex mode and Confine mode?

Confine mode:

On: child objects cannot be moved outside their enclosing parent objects.

Off: child objects can be moved outside their enclosing parent objects.

Flex mode:

On: parent borders "stretch" when child objects are moved against them.

Off: parent borders remain fixed when child objects are moved against them.

Posted Date:- 2021-10-01 10:14:30

Difference between Bind and Lexical parameters?


are used to replace a single value in sql, pl/sql

bind variable may be used to replace expressions in select, where, group, order

by, having, connect by, start with cause of queries.

bind reference may not be referenced in FROM clause (or) in place of

reserved words or clauses.


You can use lexical reference to replace the clauses appearing AFTER select,

from, group by, having, connect by, start with.

You can’t make lexical reference in pl/sql statements.

Posted Date:- 2021-10-01 10:13:44

What is the usage of the spawned object?

This object is used for process associated with executable field.

Posted Date:- 2021-10-01 09:56:51

Explain how to handle errors in the Customer interface.

We can handle errors by using SQL*Loader, or another import program, to load customer information into the interface tables.

When you import customer information, the Customer Interface program validates the global attribute columns in the interface tables and transfers those values into the customer tables.

Posted Date:- 2021-10-01 09:54:19

Difference between FORM, Function and Menu?

A menu is a hierarchical arrangement of functions and menus. Each responsibility has a menu assigned to it. A function is a part of an application that is registered under a unique name for the purpose of assigning it to be including it from a menu.

Posted Date:- 2021-10-01 09:53:45

What is Apps Schema and Schema?

Schema: Schema is the location in the database that contains database objects like views, tables, and synonyms.

Apps Schema: It is used to connect all schemas to get the information from The database.

Posted Date:- 2021-10-01 09:52:45

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.

Posted Date:- 2021-10-01 09:50:43

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.

Posted Date:- 2021-10-01 09:49:48

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.

Posted Date:- 2021-10-01 09:49:20

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.

Posted Date:- 2021-10-01 09:47:02

What is the Responsibility / Request Group?

Responsibility is used for security reasons 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 performed using all the Responsibilities that are attached with the Request group.

Posted Date:- 2021-10-01 09:46:42

What are the mandatory parameters of Procedures and what the use of those?

Errorbuf: It is used to returns the error messages and sent them to the log file.

Recode: It is used to show the status of the Procedure with 0, 1, and 2 0 for Completed Normal.

1 for Completed Warning

2 for Completed Error

Posted Date:- 2021-10-01 09:45:59

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.

Posted Date:- 2021-10-01 09:45:05

What is the US folder in the Custom Top?

It is a language-specific folder used to store the G.U.I like reports and forms.

Posted Date:- 2021-10-01 09:44:34

What is Application Top? What are the types and Purpose?

When we connect to the server we will find the top called application top. Under application top we have

Product top.

Custom top

The product top is the default top built by the manufacturer. The custom top is used to select the Client for his business purposes. Customizations are done with the Custom top.

Posted Date:- 2021-10-01 09:44:16

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.

Posted Date:- 2021-10-01 09:43:33

What Are An Adjusting Period And Its Implications?

Typically, the last day of the fiscal year is used to perform adjusting and closing journal entries. This period is referred to as Adjusting Period.

Choosing whether to include an adjusting period or not in a calendar is a very important decision. There can be an unlimited number of adjusting periods. Once the accounting calendar is used, changes to its structure to remove or add an adjusting period cannot be done.

Posted Date:- 2021-10-01 09:43:06

What Is a Value Set Security Type?

No Security: All security is disabled for this value set.
Hierarchical Security: With Hierarchical security, the features of the value security and value hierarchies are combined. With this feature, any security that applies to a parent value also applies to its child values.
Non-Hierarchical Security: Security is enabled, but the rules of the hierarchical security do not apply. That is, a security rule that applies to a parent value does not “cascade down” to its child values.

Posted Date:- 2021-10-01 09:42:26

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.

Posted Date:- 2021-10-01 09:40:49

How do I check if Multi-org is installed?

If MULTI_ORG_FLAG is set to ‘Y’, Then its Multi Org.

Posted Date:- 2021-10-01 09:39:59

What is the 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.


Posted Date:- 2021-10-01 09:39:30

Explain the 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 uses 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.

Posted Date:- 2021-10-01 09:38:53

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 a local directory and Rename it as appropriate.

Posted Date:- 2021-10-01 09:38:19

What are profile options; at what levels can these be set?

A user profile is a set of changeable options that affect the way the applications run. Oracle Does applications object Library establish a value for each option in a user's profile when the user logs on or changes responsibility.

<> System Profile: The profile option can be set for the user community.
<> User Profile: Provide Oracle Apps with standard information that describes a user, Application, Responsibility, and site. At each profile level, user profile options can be set.

Posted Date:- 2021-10-01 09:37:59

When is Custom. pll used?

Custom.pll is used while making new or customizing standard oracle forms in apps. It contains all the forms of libraries for apps.

Posted Date:- 2021-10-01 09:37:16

What is meant by 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 $_TOP).

Posted Date:- 2021-10-01 09:37:04

What is a function, how to create one?

A function is a part 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.

Posted Date:- 2021-10-01 09:36:49

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.

Posted Date:- 2021-10-01 09:36:27

What is multi-org setup?

Begin dbms_application_info.set_client_info(‘ORG_ID’);

Posted Date:- 2021-10-01 09:35:35

What are the types of Concurrent Managers 25?


* Internal Concurrent Manager (ICM): This is the one that 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 compatibility checks.

We cannot delete a concurrent manager… but we can disable it… but it’s not recommended.

Posted Date:- 2021-10-01 09:35:15

What is an application /Module?

Application is a collection of forms, function, and menus

Posted Date:- 2021-10-01 09:34:43

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.

Posted Date:- 2021-10-01 09:34:03

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.

Posted Date:- 2021-10-01 09:32:13

R4R Team
R4R provides Oracle APS Technical Freshers questions and answers (Oracle APS Technical Interview Questions and Answers) .The questions on website is done by expert team! Mock Tests and Practice Papers for prepare yourself.. Mock Tests, Practice Papers,Oracle APPS Technical interview question for experienced,Oracle APS Technical Freshers & Experienced Interview Questions and Answers,Oracle APS Technical Objetive choice questions and answers,Oracle APS Technical Multiple choice questions and answers,Oracle APS Technical objective, Oracle APS Technical questions , Oracle APS Technical answers,Oracle APS Technical MCQs questions and answers R4r provides Python,General knowledge(GK),Computer,PHP,SQL,Java,JSP,Android,CSS,Hibernate,Servlets,Spring etc Interview tips for Freshers and Experienced for Oracle APS Technical fresher interview questions ,Oracle APS Technical Experienced interview questions,Oracle APS Technical fresher interview questions and answers ,Oracle APS Technical Experienced interview questions and answers,tricky Oracle APS Technical queries for interview pdf,complex Oracle APS Technical for practice with answers,Oracle APS Technical for practice with answers You can search job and get offer latters by studing .learn in easy ways .