Top 25+ OAF Interview Questions & Answers [ ORACLE TRICKS ]
Oracle OAF Interview Questions and Answers

Top 25+ OAF Interview Questions & Answers [ ORACLE TRICKS ]

Last updated on 04th Jul 2020, Blog, Interview Questions

About author

Jagadesh (Sr OAF Consultant )

(5.0) | 16547 Ratings 5678

 These oracle OAF Interview Questions have been designed specially to get you acquainted with the nature of questions you may encounter during your interview for the subject of Oracle OAF . As per my experience good interviewers hardly plan to ask any particular question during your interview, normally questions start with some basic concept of the subject and later they continue based on further discussion and what you answer.we are going to cover top 100 Oracle OAF  Interview questions along with their detailed answers. We will be covering Oracle OAF  scenario based interview questions, Oracle OAF  interview questions for freshers as well as Oracle OAF interview questions and answers for experienced.

These Oracle OAF Interview Questions have been designed specially to get you acquainted with the nature of questions you may encounter during your interview for the subject of Oracle OAF . As per my experience good interviewers hardly plan to ask any particular question during your interview, normally questions start with some basic concept of the subject and later they continue based on further discussion and what you answer.we are going to cover top 100 Oracle OAF  Interview questions along with their detailed answers. We will be covering Oracle OAF  scenario based interview questions, Oracle OAF  interview questions for freshers as well as Oracle OAF  interview questions and answers for experienced. 

1.What is the pattern used in developing any OAF component?

Ans:

MVC (Model, View, Controller)

2.Lists the components in the MVC architecture?

Ans:

  • Model: Application Module, View Objects, View Links, Entity Objects, Entity Associations etc.
  • View: Page, Region, Attributesets etc.
  • Controller: Controller class files

3.Which is the component responsible for user actions?

Ans:

Controller is the object. The code present in ProcessFormRequest gets executed up on the user action.

4.If  we have to initialize something during the page loading, which is the right place?

Ans:

ProcessRequest() method of the Controller file is the right place.

5.What is the significance of ProcessFormData()?

Ans:

For  a ‘POST’ request the data on the page is binded to the view object in this method

6.Does ‘GET’  request result in calling ProcessFormData()?

Ans:

No, only POST request calls that.

7.What is the main Controller component in OAF?

Ans:

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

8.How does page structure get created at runtime?

Ans:

OAPageBean is responsible for creating the bean hierarchy structure at runtime after calling ProcessRequest() of each of the beans in the hierarchy.

9.What is BC4J and what are all the components of BC4J?

Ans:

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

  • A client-side user interface 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.

Components of BC4J:

  • Entity Object – 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.
  • 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 update.
  • 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.

10.What is an EO?

Ans:

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.

11.What is an VO?

Ans:

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.

12.What is an AO?

Ans:

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.

13.What is an VL?

Ans:

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.

14.What is UIX?

Ans:

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.

15.Which package should include EO and AO?

Ans:

The EO and AO will be present in the schema.server package.

16.What is the difference between inline lov and external lov?

Ans:

  • 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.

17.What is a Javabean?

Ans:

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.

18.What is query Bean?

Ans:

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

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

Ans:

  • 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.

20.What is MDS?

Ans:

MDS is 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.

    Subscribe For Free Demo

    21.What is XML?

    Ans:

    • XML is a markup language for documents containing structured information.
    • Structured information contains both content (words, pictures, etc.) and some indication of what role that content plays (for example, content in a section heading has a different meaning from content in a footnote, which means something different than content in a figure caption or content in a database table, etc.).

    22.What is Personalization?

    Ans:

    Personalization enables you to declaratively tailor the UI look-and-feel, layout or visibility of page content to suit a business need or a user preference. Some personalization examples include:

    • Tailor the order in which table columns are displayed.
    • Tailor a query result.
    • Tailor the color scheme of the UI.
    • Folder Forms
    • Forms Personalization
    • Oracle Application Framework (OAF)

    23.What is rootAM?

    Ans:

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

    24.Why should we give retainAM=Y?

    Ans:

    • 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.

    25. What are the methods in controller?

    Ans:

    •   ProcessRequest,ProcessformData and processformrequest
    •     ProcessRequest : is called when the page is requested for the first time from the server.
    •    ProcessFormRequest : is called when some event occurs on the page
    •     ProcessformData(not visible). : Used to capture Data from the form fields which the user has entered and post it into Model Layer.

      26. What is a Controller?

    Ans:

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

      27. When is the processRequest method called?

    Ans:

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

    28.When is processFormRequest method called?

    Ans:

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

    29.What is extension?

    Ans:

         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.

    30. What are levels of personalization?

    Ans:

    •      Function Level
    •      Localization Level
    •      Site Level
    •      Organization Level
    •      Responsibility Level
    •      Admin-Seeded User Level
    •      Portlet Level
    •      User Level
    Course Curriculum

    Get Hands-on Experience from Oracle OAF Certification Course

    Weekday / Weekend BatchesSee Batch Details

     31. What is BC4J?

    Ans:

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

    • A client-side user interface 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.

    32. What are Validation View Objects?

    Ans:

    They are the VVO’s used in the validation of attributes, they are the BC4J components and have their AM ie VAM Validation Application Module.

    33.Lists the components in the MVC architecture.

    Ans:

    • Model: Application Module, View Objects, View Links, Entity Objects, Entity Associations, etc.
    • View: Page, Region, Attributesets, etc.

    Controller: Controller class files.

    34.Where the VO is located in the MVC architecture?

    Ans:

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

    35. Which package should include EO and AO.

    Ans:

        The EO and AO will be present in the schema.server package.

    36.What is the difference between inline lov and external lov.

    Ans:

    •     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.

    37.what is the difference between autocustomization criteria and result based search?

    Ans:

    • 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 a search criteria.

    38.What is Activation and Passivation in OAF?

    Ans:

    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.

    39.What are the various profile options in OAF?

    Ans:

    • 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.

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

    Ans:

    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.

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

    Ans:

    • 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.

    42. What is Root Application Module?

    Ans:

    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.

    43. What are the levels of personalization?

    Ans:

    • Function Level
    •  Localization Level
    • Site Level
    •  Organization Level
    • Responsibility Level
    • Admin-Seeded User Level
    •  Portlet Level
    •  User Level

    44. What is the Association Object?

    Ans:

    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.

    45. How do you map the LOV created to your base page?

    Ans:

    One of the items in the page has to be MessageLOVInput which extends the new LOV region, apart from this LOV mapping between the base page and LOV region have to be created. 

    46.What is Validation Application Module?

    Ans:

    Validation Application Module – An application module created exclusively for the purpose of grouping and providing transaction context to related validation view objects. Typically, a standalone entity object or the top-level entity object in composition would have an associated validation application module.

    47.What is an Attribute Set?

    Ans:

    Bundles of the region or item properties that can be reused either as is or with modifications. For example, all buttons sharing the same attribute set would have the same label and Alt text.

    48. Are there any limitations in using Oracle XE?

    Ans:

     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.

    49.What is the difference between customization and extension?

    Ans:

     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.

    Using extension we can:

    • Add new functional flows
    • Extend or override existing business logic
    • Create a New application/module
    • Create a New page
    • Create New attribute
    • Extend/Override defaults & validations.

    50. How do you create a view object?

    Ans:

    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. 

    Course Curriculum

    Best Practical Oriented Oracle OAF Training By Expert Trainers

    • Instructor-led Sessions
    • Real-life Case Studies
    • Assignments
    Explore Curriculum

    51.What are the Components of OAF Page?

    Ans:

    • EO: – “Entity Object” encapsulate business rules associated  with a row in a table. Entity object has direct link with Data base table. Application interact with Database with the help of EO.
    • VO: – “View Object” helps the application to deal with the EO. View Object may base on EO or it could be based on independent sql query which has no relation with the EO.
    •  AM: -“Application Module” is a container which provide or manage access to the BC4J model object. Application module has complete control on the Application page. An OAF page cannot be run without the Application module. And we cannot access any object in the Page without the AM.
    • CO: -“Controller” responds user action and maintain application flow. Controller contains two Blocks. We write our business logic in the controller. It helps to put validation and to meet out our business logic.

    52.What are the Methods available in the Oracle Controller?

    Ans:

    • Process Request:

    When the page loads process request will fire. So, if we want to initialize some default values when the page load put this under Process Request.

    • Process form Request:

    When we press the button, Process form request executed. So, if we want to execute some code after user press the Submit button we will put under this block.

    53.What is SPEL in OAF?

    Ans:

    In Personalizations, we have two ways to change properties of the OAF Page Components like Rendered or Read Only or Required.

    • One Way to hardcode a value of True/False during personalization. This is Static Personalization
    • Second Way to do the personalization more dynamic with the help of ‘SPEL’. we can use a SPEL syntax to these properties via personalization. SPEL is nothing but an expression that returns TRUE or FALSE.

    54.What is Message File Upload in OAF?

    Ans:

    Message File Upload is one of the Item property in the OAF pages. ‘MessageFileUpload’ is one of the standard Built-in Property to create the File Upload Option in the OAF page to put the files in Oracle Apps server.

    55.What is Root AM in OAF ?

    Ans:

    Application module is the most critical component of the OAF page architecture. Any OAF page cannot be run with using the Application Module (AM). So for to run any OAF page we must need to create the OAF page. We can create and run the OAF page without , View Object (VO) and Entity Object (EO) but we cannot create the OAG page without creating Application Module. We first create the Application Module and then Attach this Application Module to that Page. If we are using the View object in the OAF Page , then again we cannot access these View Objects (VO) in that OAF page until unless we will not assign this VO to the Application Modules. Root AM in OAF is the top Most application module attached to the OAF page top region. Root AM is the Parent Application module for all other Application modules attached to the different -different regions under the Top ‘Page Layout Region’ of the Page.  When We create the OAF page , then system automatically created the First region of Style ‘ Page Layout’ we cannot change this Default region style because this inherits basic oracle application OAF page header and footer. So we create the sub-regions under this Default Page Layout region. But to run the OAF page , we must need to attach the application module so we attach the Application Module to the Top Most default Region Style “Page Layout’ and then we can also attach different AM too for the Sub -regions also. But the Top Most Region application module will be treated like the Root Application Module of the Page.

    56.Can we run the OAF Page without the Application Module?

    Ans:

    No, we cannot run the OAF page without the application Module. Application module is most important object in the OAF page to run in the Application. We can run the OAF page without VO, EO but cannot run without from AM.

    57.How to Debug and See Log Messages in OAF Pages?

    Ans:

    • Step1:- You have to Enable ‘FND: Diagnostics ‘ Profile option for the User in which you want to see these Log messages.
    • Step2:- If you want to Put the Custom Messages in your Controller then you can put these messages like below.
    • public void processRequest(OAPageContext paramOAPageContext, OAWebBean paramOAWebBean)
    •     {
    • /*This is the Custom Message which will be show in OAF page in Oracle Application*/
    •    paramOAPageContext.writeDiagnostics(this, “XX Start PR “, 1); 
    • {
    • Step3:- After Enable the Profile Option Go to the Home page of your Application.
    •  Step4:-  Then You need to Choose Diagnostic Option ‘Show Log on Screen’.
    • Step5:-  Log Level Option should Be ‘ Statement’ Then Click Go. 
    • Step6:- You can see the Log Messages shown below your OAF pages. You just need to Scroll down your Web page and you can see all these Standard and Custom messages there and can do the Debugging in that OAF page.

    58.What is Auto Customization Criteria in OAF ?

    Ans:

    Auto Customization is one of the property of the OAF search page Query Region. When we create the Search Page in OAF through Query Region then Auto Customization is one of the Property of this Region , which decides how the Search Criteria will be created for the OAF Search Page. Auto Customization Criteria Sets through Construction Mode Property of the Query Region.

     59. What are the different types of Query Region Construction Mode?

    Ans:

    •  Result Based Search
    • Auto Customization Criteria

    60.Explain the types of Exception Handling in OAF?

    Ans:

    There are 3 types of exceptions can be thrown on OAF pages (java).

    • She’sWarning  : This will display the custom message and no effect in the oaf page execution
    • Information  : This will display the custom message and no effect in the oaf page execution
    • Error : This will display the custom message and has effect in the oaf page execution.

    61.How to get the Name of the Oaf Page Components?

    Ans:

    We need to put this Below code in the Controller Process Request Method and this will give the name of the components of the OAF page.

    • // This below code will get the name of all the objects of OAF page as a Parameter.
    •  Enumeration e = pageContext.getParameterNames();
    • // This below code will print the name of the objects and their values in sequence
    •       while(e.hasMoreElements())
    •       {
    •               parameterName = (String)e.nextElement();
    •         System.out.println( “Parameter Name=>” + parameterName + ” Parameter Value=> ” + pageContext.getParameter(parameterName));  

    62.How to check the Value of View Object(VO) all Columns during Run Time of OAF Page ?

    Ans:

    • You must just put you code in the controller against the View object for which you want to know its complete details.
    • With the help of System.out.println() & Pagecontext.writediagnostics() function you can print everything about the view object in the oaf page and you will get a good understanding of the object and you can do extension in right way.
    • OAApplicationModule am = pageContext.getApplicationModule(webBean);
    •    ViewObject vo = am.findViewObject(“SupplierVO”);
    •           if (vo!=null) {
    • vo.executeQuery();
    •               while (vo.hasNext()) {
    •                       Row row = vo.next();
    •           String rowDataStr = “”;

     63.How many Types of Search Pages we can Create in the OAF ?

    Ans:

    In OAF , We can create Three Types of Search Pages in OAF Page to search the Page in the Result type table formats. These are the Below search Types available in the OAF.

    • Query Based Search Page.
    • Advanced Search Page.
    • Manaul Search Page.

    64.What are the Steps of the VO Extension in OAF ?

    Ans:

     VO Extension Steps:

    • Indentify that Which VO we need to Extend
    •  Download the VO from Oracle Java_Top Location to Your Local Desktop under My Projects folder of Your JDev setup.
    • Then We create New view Object(VO) which extends the Standard View Object.
    • Then We substitute the New Custom View Object with the Standard View Object.
    • Then we upload the New Custom View Object to Oracle Java_Top Location.
    • Then we Register the New View Object in the Oracle application Through XML Importer script.
    • After Import/Register , We add the new field in the OAF page through Personalization and then give reference in this Field for the New Custom View Object(VO).

    65.Where the  located in the MVC architecture?

    Ans:

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

    66.Steps for VO substitution?

    Ans:

    •  About this Page-> VO, AM, EO, Path of Page
    • Export Commad (in cmd Prompt)
    •  New .jpr =Open page
    • Look for AM and VO or EO.
    • Copy the class files of VO,AM or EO
    • Decompile into Java and store it into MyProjects (with respective directory structure)
    •  Open VO.xml in a new jpr
    • Create a new BC4J based on your Original VO.
    •  Create a new VO and extends original VO
    • Change the query
    • Rebuild the project
    • Go to .jpx(double click)
    • Go to Substitutions
    • Substitute Vo
    • Rebuild your Project .jpr
    • Transfer New VO class and xml to respective directory structure
    • FTP .jpx into $JAVA _TOP
    •  unix command promrt CD$ JAVA_TOP
    • jpx importer command
    • Bounce Apache Server

    67.What are different methods for passing paramaters?

    Ans:

    • Tokens

    eg. vname={@AttributeName}

    •  Hash Maps

    eg. HashMap variablename=nre HashMap();

    variablename.add(“ParameterName”,ParameterValue);

    • ThroughSession

    eg.pageContext.putSessionvalue(“ParamterName”,ParameterValue)

    68. How to setForwardURL list:

    Ans:

    There are many parameters, here is the complete list of it:-

    • public void setForwardURL(String functionName,
    •  byte menuContextAction,
    •  String menuName,
    •  com.sun.java.util.collections.HashMap parameters,
    •  boolean retainAM,
    •  String addBreadCrumb,
    •  byte messagingLevel)

    Parameters:

    • functionName – This is the function name representing the page you want to forward to. If its null, an IllegalArgumentException will be thrown.Also if the function is not under the current HOMEPAGE a OAException will be thrown.menuContextAction – Determines the behavior of the MenuContext after forwarding to the new page. It accepts the following values:OAWebBeanConstants.KEEP_MENU_CONTEXT: Keeps the menu context OAWebBeanConstants.KEEP_NO_DISPLAY_MENU_CONTEXT: Keeps the menu context as is, but will not display all menus including global buttons.OAWebBeanConstants.KEEP_NO_DISPLAY_MENU_CONTEXT_RETAIN_GLOBAL_BUTTONS: Keeps the menu context as is, but will not display all menus excluding global buttons.OAWebBeanConstants.REMOVE_MENU_CONTEXT: Removes the menu contextOAWebBeanConstants.GUESS_MENU_CONTEXT: Selects the given functionName function if it exists in the current menu. If not it will try to make a guess by moving up the menu tree until it finds it. An exception will be thrown if the function could not be located.OAWebBeanConstants.RESET_MENU_CONTEXT: Reset the menu context to the given functionName and menuName.
    • menuName – The name of the HOMEPAGE menu to reset the Menu context to when the menuContextAction is OAWebBeanConstants.RESET_MENU_CONTEXT.If the menuName is not of type HOMEPAGE a OAException will be thrown. You can pass null otherwise.

    parameters –

    • HashMap of parameter name/value pairs to append to the forward URL. The final forward URL parameters are in the following sequence:
    • It will first get the function’s corresponding URL call by querying the function information from the database. If the user is not authorized to execute this function, a security OAException will be thrown.
    • It will then append all parameters passed in the parameters HashMap. First parameter added to the HashMap will be first added to the URL. Also the framework will encode all parameter values before appending them to the URL.
    • It will remove all parameters if they have null values in the passed parameters HashMap. This provides an easy way for developers to set a certain parameter’s value to null if they want to remove it.
    • It will remove any OA Framework internal URL parameters such as bcrumb, retainAM, and so on..
    • retainAM – If true, all the cached application modules will be retained. If false, all the cached application modules will be released.Developers must use this parameter to control the release behavior of the cached appplication modules.This method will ignore any retainAM=true or retainAM=false as a URL parameter or as part of parameters

    69. How to apply Code to copy rows in VO ?

    Ans:

    • public void copy()
    •  {
    •  SuppliersVOImpl pervo = getSuppliersVO1();
    •  Row row[] = pervo.getFilteredRows(“SelectFlag”,”Y”);
    •  for (int i=0;i<row.length;i++)
    •  {
    •  SuppliersVORowImpl rowi = (SuppliersVORowImpl)row;
    •  OADBTransaction trx = (OADBTransaction)getTransaction();
    •  Number b = trx.getSequenceValue(“FWK_TBX_SUPPLIERS_S”);
    •  AttributeList a = (AttributeList)rowi;
    •  SuppliersVORowImpl r =(SuppliersVORowImpl)pervo.createAndInitRow(a);
    •  //Set here your unique attribute values, I’m setting here Supplier Id as for every new row it should be different.
    •  r.setSupplierId(b);
    •  pervo.insertRow(r);
    •  }
    •  }

    70.what for isPreparedForExecution() and executeQuery() methods used?

    Ans:

    • isPreparedForExecution function will check whether all parameters are assigned properly and 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 database into VO cache.
    Oracle OAF Sample Resumes! Download & Edit, Get Noticed by Top Employers! Download

    71.What are the primary functions of EO?

    Ans:

    • EO encapsulates the business logic and rules.
    • EO’s are used for Inserting, Updating and Deleting data. 
    • We can also link to other EO’s and create an Association object.
    • Map to a database table or other data source
    • Each entity object instance represents a single row
    • Contain attributes representing database columns
    • Central point for business logic and validation related to a table
    • Encapsulates attribute-level and entity-level validation logic
    • Can contain custom business methods

    72.What are the primary functions of VO?

    Ans:

    • View object encapsulates the database query.
    • It is used for selecting data.
    • Are used for joining, filtering, projecting, and sorting your business data
    • Represent a query result
    • It provides iteration over a query result set.
    • Can be based on any number of entity objects if the underlying UI is for update.
    • Can also be constructed from a SQL statement
    • It provides a single point of contact for getting and setting entity object values.
    • It can be linked together to form View Links.

    73.What are the common methods used in a oaf controller and when they are executed?

    Ans:

    Processrequest and ProcessForRequest. when the loads first time the ProcessRequest get execute and when any action fire then ProcessFormrequest get execute.

    74.Tell me the practical steps for extension of a view object, starting from $JAVA_TOP to jDeveloper

    Ans:

    Get the VO object from java Top which we want to extend and keep it inside Jdveloper myprojects. Then create a new VO and select the extends option as the parent vo which is going to be extended. This will be done in JDeveloper wizard. Now the parent vo sql will be shown in Jdeveloper wizard (sql editor) and as per our requirement we can modify or can add new attributes.Once this vo creation is complete we have to right click on project and select the substitution option.their we have to choose the old vo and new vo.Once it is done the substitution is complete.we need to compile the project.After compilation a xml entry will be created in jpx file. the jpx file genrally is the name of project.So now we need to import the jpx to MDS and have to move the java and vo xml to java top.

    75.Please tell me the scenario in which extension to View Object is not upgrade safe?

    Ans:

    If the original view object was created in expert mode, then you will have to copy the Original VO Query and then you will paste that SQL Stmt/Query into the extended View Object. Now, if in future Oracle is going to change the original SQL Statement [against original VO], then those changes will not be reflected in extended View Object. Is there any solution? Well, yes, depends on what you wish to achieve via personalization. If you simply wish to alter the where clause dynamically, then you might as well do that by extending the controller. But to add new attributes we have to extend the vo. so after patch we have to recreate the custom vo and have to deploy again.

    76.In Oracle Forms, we have WHEN-VALIDATE-RECORD? What will be the equivalent to that in OAFramework?

    Ans:

     We can do the attribute validations in entity obejct and for that we can use a method named validateEntity() within the Entity Object.

    77.How do you disable all the OA Framework personalizations in eBusiness .

    Ans:

    All the personalizations done to the system can be disabled by simply setting a profile option to Yes at site level. 

    78.What is the significance of addBreadCrumb=Y?

    Ans:

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

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

    Ans:

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

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

    Ans:

    Jad is one of the tool for decompiling the java class.

    81.What is APEX syntax?

    Ans:

    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.

    82.Why can’t Root AM be extended?

    Ans:

    The root AM is loaded first and after that, the MDS Substitutions are parsed.Hence ROOT AM gets loaded even before the time the substitutions definition from MDS layer gets worked out.

    83. What is the substitution?

    Ans:

    When view objects are extended, we need to tell the applications that our extended view object should be used or substituted during runtime, substitution will serve this purpose.

    84. What is ‘Partial Page Rendering’ PPR?

    Ans:

     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. 

    85.what is MVC Architecture?

    Ans:

    MVC Architecture is a Model View Controller Architecture. The controller responds to user actions and directs application flow. The model encapsulates underlying data and business logic of the application. The view formats and presents data from a model to the user.

    86. How do you add a link to OAF Page?

    Ans:

    Create a new item with style as a link and give its destination URI property which is the URL where you want to navigate to.

    87. What is View Link?

    Ans:

     Establishes a master/detail relationship between two view objects.

    88. What is BLOB datatype?

    Ans:

    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.

    89. What are the SET operators?

    Ans:

    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.

    90.What is the sequence of Personalization override?

    Ans:

    • Responsibility Level
    • Site Level
    • Function Level
    • Organization Level
    • User Level

    91.What is Entity Expert?

    Ans:

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

    92. When is the process request method called?

    Ans:

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

    93.How does personalization take its effect at runtime?

    Ans:

     After the page structure or bean hierarchy is formed with, the personalization layers get applied on top of it to come up with the final structure. Remember that is the reason why personalization is upgraded safe.

    Are you looking training with Right Jobs?

    Contact Us
    Get Training Quote for Free