OAF interview questions for freshers/OAF Interview Questions and Answers for Freshers & Experienced

What is the pattern used in developing any OAF component?

MVC (Model, View, Controller)
Lists the components in the MVC architecture
Model: Application Module, View Objects, View Links, Entity Objects, Entity Associations, etc.
View: Page, Region, Attributesets, etc.
Controller: Controller class files

What for isPreparedForExecution() and executeQuery() methods used?

PreparedForExecution function will check whether all parameters are assigned properly and the query is ready for execution.
On multiple navigations to the page, this query will not be executed multiple times.
While executeQuery function is used for executing the VO query so that it can fetch the data from the database into VO cache.

What is the difference between auto-customization criteria and result based search?

Results based search generates search items automatically based on the columns on the results table.

In Auto-customization search we need to set what all fields are required to display as search criteria.

What is Entity Expert?

A special singleton class registered with an entity object (EO) that performs operations on behalf of the EO.

What are the SET operators?

The following are the advantages of APEX:

* No license required it is free.
* To build an application it is a fast learning curve for developers.
* We can build web applications that are fast & secure through APEX.
* There is a lot of scope for customization of the
* application as per our requirement.
* Deployment of application is very simple as
* “Import & Export”. If any hard code with reference to values varies between environments are avoided.
* Apex Framework & meta-data is stored in Oracle tables. It runs on live Oracle DB’s.

What is BLOB datatype?

A BLOB data type is a binary string with a varying length which is used in storing two gigabytes memory. Length should be stated in Bytes for the BLOB.

What is the difference between inline lov and external lov?

Inline lov is a lov which is used only for that particular page for which it was created and cannot be used by any other page. External lov is a common lov which can be used by any page. It is a common component for any page to use it. It can be used by giving the full path of the love in the properties section “External LOV” of the item.

What is ‘Partial Page Rendering’ PPR?

PPR is a mechanism where in only the required part of the page is refreshed as against the whole page. The page objects fire the ‘events’ and accordingly the request is handled in the controller file.

What is APEX syntax?

APEX syntax has different features such as a variable declaration to store the different values in the memory. The queries will be like SOQL which will be used to execute the queries, loop statements to perform the iterations in performing the operations, flow control statements can be used to control the flow execution whether to start or stop the execution process, DML statements can be used to manipulate the data by executing the queries.

What are the tools you had used for decompiling java class?

Jad is one of the tool for decompiling the java class

How do you find right jdev patch for your oracle application version?

Search in oracle.metalink.com as Jdev with OA Extension.

What is the significance of addBreadCrumb=Y?

The basic intention of the breadcrumb is to let the user know of the navigation path he took to reach the current page.

Why should we give retainAM=Y?

The AM should be retained whenever you are navigating away from a page and when you know that there is a possibility to come back to the page again and data is to be retained.

Example: Any navigation link that opens in a new page or any navigation which has a back button to come back to the initial page.

kThe AM should not be retained for two independent pages, especially if they have common VOs which fetch different result sets. In such cases, retaining the AM may not remove the cache of VOs and so the result may not be as expected.

What is rootAM?

The application module which is associated with the top-level page region (the pageLayout region) is root application module.

How do you create a view object?

View objects can be created in the Business components package, can be based on entity objects or an sql query. View objects based on sql query are read-only view objects.

What is the main Controller component in OAF?

OAController is the main class and our controller will become a subclass of it.

What is the difference between customization and extension?

Customization is under direct user control. The user explicitly selects between certain options. Using customization a user can:

* Altering the functionality of an application
* Altering existing UI
* Altering existing business logic

The extension is about extending the functionality of an application beyond what can be done through personalization.

Are there any limitations in using Oracle XE?

XE is free but Oracle has built certain limitations into the product. The first limitation is memory. Oracle Database XE can address only 1GB of RAM. This limitation mainly affects how many users can access the database concurrently and how well it performs. The second limit is that XE will only use one CPU. XE will run on a multi -CPU computer but won’t scale up to use those CPUs. This functionality requires Oracle Database Standard Edition or Enterprise Edition. The third limit is that only a single XE database can run on any given computer. You do not need a database for each application. Instead, Oracle uses the concept of schemas to separate applications. Finally, a 4GB limit is enforced on disk space. 4GB is a huge amount of storage for most applications. You can also use APEX to link to other databases (on other servers) for more storage as needed.

What is the Association Object?

BC4J association objects implement the relationships between entity objects. For example, a purchase order header can reference a supplier, or it can own its order lines.

What are the levels of personalization?

1. Function Level
2. Localization Level
3. Site Level
4. Organization Level
5. Responsibility Level
6. Admin-Seeded User Level
7. Portlet Level
8. User Level

What is the difference between auto customization criteria and result-based search?

Results-based search generates search items automatically based on the columns on the results table.
In Autocustomization search we need to set what all fields are required to display as search criteria.

What is the difference between inline lov and external lov?

Inline lov is a lov that is used only for that particular page for which it was created and cannot be used by any other page.
External lov is a common lov that can be used by any page. It is a common component for any page to use it. It can be used by giving the full path of the love in the properties section “External LOV” of the item.

What is Root Application Module?

Each page layout region in an OA Framework application is associated with a “root” application module which groups related services and establishes the transaction context. This transaction context can be shared by multiple pages if they all reference the same root application module, and instruct the framework to retain this application module (not return it to the pool) when navigating from page to page within the transaction task.

Where the VO is located in the MVC architecture?

VO is located in the View Layer in MVC which is responsible for presenting the data to the user.

What is UIX?

UIX is an extensible, J2EE-based framework for building web applications. It is based on the Model-View-Controller (MVC) design pattern, which provides the foundation for building scalable enterprise web applications.

What is a VL?

A view link is an active link between view links. A view link can be created by providing the source and destination views and source and destination attributes. There are two modes of View link operation that can be performed. A document and Master/Detail operation.

what is the difference between auto customization criteria and result based search?

Results based search generates search items automatically based on the columns on the results table.
In Autocustomization search we need to set what all fields are required to display as search criteria.

What is the difference between auto-customization criteria and result based search?

Results based search generates search items automatically based on the columns on the results table.

In Auto-customization search we need to set what all fields are required to display as a search criteria.

What is query Bean?

QueryBean is used to execute and return the results of a query on behalf of the QueryPortlet application.

What is a Javabean?

JavaBeans is an object-oriented programming interface that lets you build re-useable applications or program building blocks called components that can be deployed in a network on any major operating system platform.

What are all the components of BC4J?

Following are the components of BC4J:
1. Entity Object – EO encapsulates business logic and rules. EO’s are used for Inserting, Updating, and Deleting data from the database table. E0 is also used for validating the records across the applications.
2. View Object – View object encapsulates the database query. It is used for selecting data. It provides iteration over a query result set. VO’s are primarily based on EO’s. It can be used on multiple EO’s if the UI is for the update.
3. Application Module – Application Modules serve as containers for related BC4J components. The pages are related by participating in the same task. It also defines the logical data model and business methods needed.

What is the difference between inline lov and external lov?

Inline lov is a lov which is used only for that particular page for which it was created and cannot be used by any other page.

External lov is a common lov which can be used by any page. It is a common component for any page to use it. It can be used by giving the full path of the lov in the properties section “External LOV” of the item.

What is BC4J?

Business Components for Java is JDeveloper’s programming framework for building multi-tier database applications from reusable business components. These applications typically consist of:

• A client-side user interface is written in Java and/or HTML.
• One or more business logic tier components that provide business logic and views of business objects.
• Tables on the database server that store the underlying data.

What is UIX?

UIX is an extensible, J2EE-based framework for building web applications. It is based on the Model-View-Controller (MVC) design pattern, which provides the foundation for building scalable enterprise web applications.

What is an VL?

A view link is an active link between view links. A view link can be created by providing the source and destination views and source and destination attributes. There are two modes of View link operation that can be performed. A document and Master/Detail operation.

What is an AO?

An association object is created where we link EO’s. For example take the search page where we link the same EO to form a association between the manager and employee. Every employee should have a manager associated. But if it President then no there is no manager associated. This is a perfect example to understand the AO.

What is an VO?

View object encapsulates the database query. It is used for selecting data. It provides iteration over a query result set. VO’s are primarily based on Eo’s. It can be used on multiple EO’s if the UI is for update. It provides a single point of contact for getting and setting entity object values. It can be linked together to form View Links.

What is an EO?

EO encapsulates the business logic and rules. EO’s are used for Inserting, Updating and Deleting data. This is used for validating across the applications. We can also link to other EO’s and create a Association object.

What is a switcher in oAF and when it is used?

A switcher controls, that allows the selective display of information. For example, if you want to display an image for update enabled and update disabled you can use switcher.

What is Personalization?

Oracle Apps Framework has an OA Personalization Framework associated with it so that you can personalize any OAF page in an Oracle E-business Suite application without changing the basic or underlying code of that OA Framework page, Oracle Application Framework makes it very easy to personalize the appearance of the page or even the personalization of data displayed on to an OA Framework page.

What is MDS?

MDS is a MetaData Service. When a web page is broken into small units like buttons, fields, etc they are stored in a database. These are not stored as binary files but as data in tables. The data are present in JDR tables. MDS provides service to store & return page definitions. MDS collects those definitions in components/fields in a meaningful manner to build a page.

Which is the component responsible for user actions?

The controller is the object. The code present in ProcessFormRequest gets executed upon the user action.

What are the various profile options in OAF?

<> FND Diagnostics: required for ABOUT THIS PAGE and Diagnostic link on-page.
<> Personalize Self Service Definitions: To enable Personalize page link on the page.
<> FND Personalization Region Link Enabled: used to enable Region Personalization links at every region.
<> FND Migrate to JRAD: By default set to Yes. The page would run from MDS if Yes, else it will run from AK.
<> FND Document root path: required for personalization
migration. It is set to the path of the MDS folder on the respective servers.
<> FND Branding image:
<> FND Banding Size: these profiles options are used for changing standard image (Oracle) on the page.

what is a Javabean?

JavaBeans is an object-oriented programming interface that lets you build re-useable applications or program building blocks called components that can be deployed in a network on any major operating system platform.

What is Activation and Passivation in OAF?

Passivation is the process of saving application state to a secondary medium (the database) at specific event points so it can be restored (activated) when needed. This restoration of data is called Activation. Passivation in OAF is done implicitly when the appropriate profile options are enabled.

What is personalization?

Oracle Apps Framework has an OA Personalization Framework associated with it so that you can personalize any OAF page in an Oracle E-business Suite application without changing the basic or underlying code of that OA Framework page, Oracle Application Framework makes it very easy to personalize the appearance of the page or even the personalization of data displayed on to an OA Framework page.

What is an extension?

The extension is when you take an already existing component ex an OAF page or a region and then add some more functionality to it without disturbing the original functionality.

When is the processFormRequest method called?

PFR method is called when we perform some action on the screen like the click of submit button or click on lov

When is the process request method called?

PR method is called when the page is getting rendered onto the screen

What is a Controller?

The controller is the java file and can be associated with a complete OAF page or to a specific region.

There are several tasks you will do routinely in your code.

1. Handle button press and other events

2. Automatic queries

3. Dynamic WHERE clauses

4. Commits

5. JSP Forwards

The logic for accomplishing all these tasks is written in the controller

Search
R4R Team
R4R provides OAF Freshers questions and answers (OAF Interview Questions and Answers) .The questions on R4R.in website is done by expert team! Mock Tests and Practice Papers for prepare yourself.. Mock Tests, Practice Papers,OAF interview questions for freshers,OAF Freshers & Experienced Interview Questions and Answers,OAF Objetive choice questions and answers,OAF Multiple choice questions and answers,OAF objective, OAF questions , OAF answers,OAF MCQs questions and answers Java, C ,C++, ASP, ASP.net C# ,Struts ,Questions & Answer, Struts2, Ajax, Hibernate, Swing ,JSP , Servlet, J2EE ,Core Java ,Stping, VC++, HTML, DHTML, JAVASCRIPT, VB ,CSS, interview ,questions, and answers, for,experienced, and fresher R4r provides Python,General knowledge(GK),Computer,PHP,SQL,Java,JSP,Android,CSS,Hibernate,Servlets,Spring etc Interview tips for Freshers and Experienced for OAF fresher interview questions ,OAF Experienced interview questions,OAF fresher interview questions and answers ,OAF Experienced interview questions and answers,tricky OAF queries for interview pdf,complex OAF for practice with answers,OAF for practice with answers You can search job and get offer latters by studing r4r.in .learn in easy ways .