1) What is a interface?
In terms of oracle applications interface is a communication channel that allows the data to move in and out of the system.
2) How many types of interfaces are there?
1.INBOUND INTERFACES
2.OUTBOUND INTEFACES
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.
3) What are different types of inbound interfaces available?
1.Open interfaces
2.API's(Application Program Interface)
3.EDI(Electronic Data interchange)--Mainly used for automation transactions with third party systems
4.XML GATEWAY --Mainly used for automation transactions with third party systems
5.WEBADI--Used for uploading data from excel with the scope to have some validations--mainly used for one time loading..Just like sqlloader+validation program..
5.PLSQL Packages for Reading XML Data--Use this in case of importing non stadard transactions
4) What are different types of outbound interfaces available?
1.Custom programs where we pull data to a csv file using UTL_FILE in the required format
2.EDI
3.XMLGATEWAY
4.PLSQL Packages for generating XML
5) what is the difference between OPEN INTERFACE & API's?
OPEN INTERFACE:
I dont see much difference between the open other than the way we load data.
In case of open interface the data is loaded in to open interfce 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 you check the errror 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 paremeters to take the advantage of bulk binding concepts for faster loading data.
THey will have the two OUT parameterst to throw back the error code and message in case of data validation failure
Apis' are compartively faster than open interfaces.
If a API's and open interface are available it is better to load through API's.If the records are more...
6) 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.
7) What is the Role of Concurrent Managers?
A Concurrent Manager is a component of Concurrent processing that monitors and runs tasks without tying up your computer.
8) What is AOL?
Oracle Applications are constructed and maintained using the Application Object Library (AOL). The Three main areas of AOL are (i) Applications Security (ii) Operating Profile (iii) Concurrent Processing
9)Define Interfaces.
What are the different types of Interfaces?
Interfaces are used to integrate external systems and data conversion in Oracle Applications. These can be used to either transfer data from Oracle Applications to a Flat File or Data from Legacy System to Oracle Applications. There are two types of Interfaces. Inbound and Outbound Interfaces. Inbound Interfaces are used to transfer data from external system to Oracle Applications. Outbound Interfaces are used to transfer data from Oracle Applications to External System. Open Interface is the interface whose interface logic is provided by Oracle. Custom Interface is an Interface whose logic is developed by implementation team.
10) What are alerts?
What are the different types of alerts? Explain. Alerts Immediately inform you of the database activity as it happens. Can Periodically trigger off events as and when required Can take predefined actions Allow you to define distribution list Can keep history of the exceptions and actions taken against them. There are two types of alerts. Event Alerts Periodic Alerts
11) What is the Flex field? What are the types of Flex field?
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 Key Flex Field and Descriptive Flex Fields
-- -- -- -- For more info follow Link Oracle Apps Interview Qustions
12) What are the tables related to flex field?
FND_FLEX_VALUES
FND_FLEX_VALUE_SETS
FND_FLEX_VALUES_TL
13) What is AD_DD package?
AD_DD Package is used to register the Table, Columns, and Primary Key in Oracle Applications.
14) What are the types of Value sets?
· None
· Table
· Special
· Pair
· Dependent
· Independent
· Translatable Dependent
· Translatable Independent
15) What are the Special and Pair Flex Field?
Special – Value Sets uses FlexField itself Pair – Two Flex Fields together specifies a range of valid values.
16) What are the Translatable Dependent and Independent Flex Fields?
Translatable Independent – Input must exist on previously defined set List of
Values. Translated value can be used.
Translatable Dependent means Input is checked against a subset of values
Based on a prior value. Translated value can be used.
17) What is FND_REQUEST.SUBMIT_REQUEST?
Submits a Concurrent Request for Processing by a Concurrent Manager.
18) What is Client Info?
By calling this Program in SQL*PLUS or reports with correct parameters user can achieve concurrent program environment for testing. FND_CLIENT_INFO.setup_client_info(application_id Number,
Responsibility_id Number,
User_id Number,
Security_Group_id Number);
19) Give the Directory structure in apps?
$APPL_TOP - Product Directory- Version-
20) What are the steps in Registering Concurrent Program?
Go to Programs and Define Executables. Go to Programs and Define Concurrent Program Go to Responsibility and attach the Request group you want.
21) What are the different types of executable available in Concurrent Programming?
Host Oracle Reports PL/SQL Stored Procedures SQL*LOADER SQL*PLUS Spawned JSP
22) What are Request Sets?
Request set is a collection of Reports/Programs that you group together and can be submitted to run is a single interaction.
23) What is Standard Request Submission (SRS Feature)?
SRS provides you 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.
24) What are the different API’s for Concurrent Programming?
.FND_CONCURRENT
.FND_FILE
.FND_PROGRAM
.FND_SET
.FND_REQUEST
.FND_REQUEST_INFO
.FND_SUBMIT
25) What are the Different PLL’s Used in Forms?
.CUSTOM.pll
.FNDSQF.pll
.APPCORE.pll
.APPCORE2.pll
.appdaypk.pll
.APPSTAND.pll
26) What are the Steps in Forms Customization?
Define the Form Name in FORM Screen Define Form Functions Attach to Menu/Attach to Request group
27) What are the triggers that can be modified during Forms Customization?
Pre-Forms ,When-New-Form-Instance ,Query_Find ,Post-Form ,Key-Clrfrm
28) What are the triggers that cannot be modified during Forms Customization?
STANDARD_ATTACHMENT, ZOOM ,FOLDER_ACTION ,KEY-HELP, KEY-EXIT, KEY-COMMIT, WHEN-WINDOW_CLOSED ,CLOSE_WINDOW
29) What are the FlexField Qualifiers?
A Flex field qualifier identifies a particular segment of a key flex field.
30) What are the Segment Qualifiers?
A Segment Qualifier identifies a particular type of value in a single segment of a key flex field.
31) What is a Dynamic Insertion?
Dynamic Insertion is the insertion of new valid combination into a Key Flexfields Combinations Table from a form other than the combinations form. All Validation rules still will apply during insertion.
32) What are the different Level of Profiles?
User Profiles are used To set options that affect your applications behavior o your preference. A Collection of changeable options that affect the way your applications run Modify Product Specific variables Gives Control over certain Oracle Applications features.
In terms of oracle applications interface is a communication channel that allows the data to move in and out of the system.
2) How many types of interfaces are there?
1.INBOUND INTERFACES
2.OUTBOUND INTEFACES
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.
3) What are different types of inbound interfaces available?
1.Open interfaces
2.API's(Application Program Interface)
3.EDI(Electronic Data interchange)--Mainly used for automation transactions with third party systems
4.XML GATEWAY --Mainly used for automation transactions with third party systems
5.WEBADI--Used for uploading data from excel with the scope to have some validations--mainly used for one time loading..Just like sqlloader+validation program..
5.PLSQL Packages for Reading XML Data--Use this in case of importing non stadard transactions
4) What are different types of outbound interfaces available?
1.Custom programs where we pull data to a csv file using UTL_FILE in the required format
2.EDI
3.XMLGATEWAY
4.PLSQL Packages for generating XML
5) what is the difference between OPEN INTERFACE & API's?
OPEN INTERFACE:
I dont see much difference between the open other than the way we load data.
In case of open interface the data is loaded in to open interfce 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 you check the errror 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 paremeters to take the advantage of bulk binding concepts for faster loading data.
THey will have the two OUT parameterst to throw back the error code and message in case of data validation failure
Apis' are compartively faster than open interfaces.
If a API's and open interface are available it is better to load through API's.If the records are more...
6) 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.
7) What is the Role of Concurrent Managers?
A Concurrent Manager is a component of Concurrent processing that monitors and runs tasks without tying up your computer.
8) What is AOL?
Oracle Applications are constructed and maintained using the Application Object Library (AOL). The Three main areas of AOL are (i) Applications Security (ii) Operating Profile (iii) Concurrent Processing
9)Define Interfaces.
What are the different types of Interfaces?
Interfaces are used to integrate external systems and data conversion in Oracle Applications. These can be used to either transfer data from Oracle Applications to a Flat File or Data from Legacy System to Oracle Applications. There are two types of Interfaces. Inbound and Outbound Interfaces. Inbound Interfaces are used to transfer data from external system to Oracle Applications. Outbound Interfaces are used to transfer data from Oracle Applications to External System. Open Interface is the interface whose interface logic is provided by Oracle. Custom Interface is an Interface whose logic is developed by implementation team.
10) What are alerts?
What are the different types of alerts? Explain. Alerts Immediately inform you of the database activity as it happens. Can Periodically trigger off events as and when required Can take predefined actions Allow you to define distribution list Can keep history of the exceptions and actions taken against them. There are two types of alerts. Event Alerts Periodic Alerts
11) What is the Flex field? What are the types of Flex field?
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 Key Flex Field and Descriptive Flex Fields
-- -- -- -- For more info follow Link Oracle Apps Interview Qustions
12) What are the tables related to flex field?
FND_FLEX_VALUES
FND_FLEX_VALUE_SETS
FND_FLEX_VALUES_TL
13) What is AD_DD package?
AD_DD Package is used to register the Table, Columns, and Primary Key in Oracle Applications.
14) What are the types of Value sets?
· None
· Table
· Special
· Pair
· Dependent
· Independent
· Translatable Dependent
· Translatable Independent
15) What are the Special and Pair Flex Field?
Special – Value Sets uses FlexField itself Pair – Two Flex Fields together specifies a range of valid values.
16) What are the Translatable Dependent and Independent Flex Fields?
Translatable Independent – Input must exist on previously defined set List of
Values. Translated value can be used.
Translatable Dependent means Input is checked against a subset of values
Based on a prior value. Translated value can be used.
17) What is FND_REQUEST.SUBMIT_REQUEST?
Submits a Concurrent Request for Processing by a Concurrent Manager.
18) What is Client Info?
By calling this Program in SQL*PLUS or reports with correct parameters user can achieve concurrent program environment for testing. FND_CLIENT_INFO.setup_client_info(application_id Number,
Responsibility_id Number,
User_id Number,
Security_Group_id Number);
19) Give the Directory structure in apps?
$APPL_TOP - Product Directory- Version-
20) What are the steps in Registering Concurrent Program?
Go to Programs and Define Executables. Go to Programs and Define Concurrent Program Go to Responsibility and attach the Request group you want.
21) What are the different types of executable available in Concurrent Programming?
Host Oracle Reports PL/SQL Stored Procedures SQL*LOADER SQL*PLUS Spawned JSP
22) What are Request Sets?
Request set is a collection of Reports/Programs that you group together and can be submitted to run is a single interaction.
23) What is Standard Request Submission (SRS Feature)?
SRS provides you 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.
24) What are the different API’s for Concurrent Programming?
.FND_CONCURRENT
.FND_FILE
.FND_PROGRAM
.FND_SET
.FND_REQUEST
.FND_REQUEST_INFO
.FND_SUBMIT
25) What are the Different PLL’s Used in Forms?
.CUSTOM.pll
.FNDSQF.pll
.APPCORE.pll
.APPCORE2.pll
.appdaypk.pll
.APPSTAND.pll
26) What are the Steps in Forms Customization?
Define the Form Name in FORM Screen Define Form Functions Attach to Menu/Attach to Request group
27) What are the triggers that can be modified during Forms Customization?
Pre-Forms ,When-New-Form-Instance ,Query_Find ,Post-Form ,Key-Clrfrm
28) What are the triggers that cannot be modified during Forms Customization?
STANDARD_ATTACHMENT, ZOOM ,FOLDER_ACTION ,KEY-HELP, KEY-EXIT, KEY-COMMIT, WHEN-WINDOW_CLOSED ,CLOSE_WINDOW
29) What are the FlexField Qualifiers?
A Flex field qualifier identifies a particular segment of a key flex field.
30) What are the Segment Qualifiers?
A Segment Qualifier identifies a particular type of value in a single segment of a key flex field.
31) What is a Dynamic Insertion?
Dynamic Insertion is the insertion of new valid combination into a Key Flexfields Combinations Table from a form other than the combinations form. All Validation rules still will apply during insertion.
32) What are the different Level of Profiles?
User Profiles are used To set options that affect your applications behavior o your preference. A Collection of changeable options that affect the way your applications run Modify Product Specific variables Gives Control over certain Oracle Applications features.
No comments:
Post a Comment