Oracle Apps - FAQ's - Interview Questions

Oracle Apps - FAQ's - Interview Questions

Would like to share some FAQ in Oracle Apps

What is the Flexfield? What are the types of Flexfield? 
Flex Field is “Flexible Field”. A Flexfield is made up of Segments. Each segment has a name that can be assigned and has set of valid values.

There are two types of Flex field

1. Key Flexfields

2. Descriptive Flexfields

What are the tables related to Flexfield?
1. FND_FLEX_VALUES 
2. FND_FLEX_VALUE_SETS 
3. FND_FLEX_VALUES_TL 

What are the types of Value sets? 
1. None 
2. Table 
3. Special 
4. Pair 
5. Dependent 
6. Independent 
7. Translatable Dependent 
8. Translatable Independent

What are the Special and Pair Flexfield? 

Special – Value Sets uses Flex field itself

Pair – Two Flex Fields together specifies a range of valid values.

What are the Flexfield Qualifiers? 
A Flex field qualifier identifies a particular segment of a key flex field.

What are the Segment Qualifiers?
A Segment Qualifier identifies a particular type of value in a single segment of a key flex field.

What are the different Level of Profiles? 
User Profiles are used to set options that affect the applications behaviour. A Collection of changeable options that affect the way your applications run Modify Product Specific variables Gives Control over certain Oracle Applications features.

What is Concurrent Programming? 
Concurrent Processing in Oracle Apps simultaneously executes programs running in the Background with online operations to fully utilize your hardware capacity. Use Concurrent Programming for Long Running – Data intensive tasks such as Posting a Journal or generating a report.

What is the Role of Concurrent Managers?  
A Concurrent Manager is a component of concurrent processing that monitors and runs tasks without tying up the system.

What are Request Sets? 
Request set is a collection of Reports / Programs that is to be group together and can be submitted to run is a single interaction.

What is Standard Request Submission (SRS Feature)?
SRS provides with a set of windows for running reports and Programs and a set of windows for creating groups of reports and programs to run together. Features Specify whether reports or programs in a request set run sequentially or simultaneously Specify whether to continue with a request set if a report or program in a sequential set fails View a log file Specify alternative requests based on completion status of previously run requests in a request set.

What is an interface?
In terms of oracle applications interface is a communication channel that allows the data to move in and out of the system.

How many types of interfaces are there?
1. Inbound Interfaces
2. Outbound Interfaces

Inbound Interface:

The one which allows data to get into oracle application from outside is called inbound interface.
Outbound Interface:

The one which allows data to get data from oracle applications to other systems is called outbound interface.

What is the difference between Open Interface & API's?
Open Interface:
There is no much difference between the open other than the way we load data.
In case of open interface the data is loaded in to open interface table like GL_INTERFACE or Sales Order Interface (OE_ORDER_HEADERS_IFACE_ALL).
Run the interface import program.
This will validate the data and put it into oracle applications. All the invalid records are marked as Error.
One thing is there are GUI Screens available for most of these interface where to check the error message correct it there only and resubmit the interface.
From the technical perspective there are Error tables available for each interface

API:
API's are the oracle built packages where the validation logic is wrapped inside a package and the data is passed as parameters to the API.
Most of these API’s use the PLSQL tables as parameters to take the advantage of bulk binding concepts for faster loading data.
They will have the two OUT parameters to throw back the error code and message in case of data validation failure
APIs' are comparatively faster than open interfaces.
If an API's and open interface are available it is better to load through API's. If the records are more.

What are alerts? What are the different types of alerts?

Alerts immediately informs the database activity as it happens. Can periodically trigger off events as and when required can take predefined actions and allows to define distribution list can keep history of the exceptions and actions taken against them.

There are two types of alerts.

1. Event Alerts

2. Periodic Alerts