|Receive Email for New Articles|
|OA Framework Interview Questions||| Print ||
|Written by Anil Passi|
|Friday, 29 February 2008|
More and more jobs demand OA Framework skillsets these days.
In fact it is safe to say that you would need OA Framework development experience to have an edge as an Oracle Applications Consultant.
Indeed OA Framework will become a thing of past with Fusion, however
OA Framework will be used for next at least 5 to maximum 10 years
The concepts of OAF, specifically BC4J, can be carried forward to ADF.
I am listing hereby the questions that I would ask for an OA Framework Interview.
As a thumb rule, interview questions should always be based on basic & practical concepts.
Please remember that, as an Oracle Apps Consultant, more often that not, you will be required to do extensions rather than pure development.
Indeed, some component of extensions will call for development of new pages.
These questions will lay more emphasis on OA Extensions, which is what OAF Consultants will most likely be working on.
One last piece of advice, the purpose of these questions is not only to help you with interviews, but in reality it is to help you clear your practical concepts on OA Framework.
You wish to hide a bean/field programmatically, where will you do that?
a. In controller
b. In Application Module
c. In Entity Object
d. In View Object
Answer:- In controller[Although SPEL with limited usage can also be considered]
The remainder questions are best left interactive.
Please quote the Question Number in comments when putting your thoughts on any individual question.
Within which method of Controller will you hide that bean/field/button/region programmatically?
3. Both processRequest and processFormRequest
Tell me the practical steps for extension of a view object, starting from $JAVA_TOP to jDeveloper
Please tell me the scenario in which extension to View Object is not upgrade safe?
In Oracle Forms, we have WHEN-VALIDATE-RECORD? What will be the equivalent to that in OAFramework?
How do you disable all the OA Framework personalizations in eBusiness Suite
How do you disable all the OA Framework extensions in eBusiness Suite
You are working on two projects, both involve OA Framework.
One instance is on 11.5.10-Rollup2
Other instance is on R12-Rollup4
Can you setup up development environment for both these instances on your PC/Laptop? If yes, then please explain how.
Can you add new columns to an Advanced Table region/section using personalization?
Tell me one scenario in which you would have to extend Application Module?
Can you extend every possible Application Module?
A slightly advanced question will be…Why can’t Root AM be extended?
How would you know whether the AM that you are trying to extend is the RootAM?
Which two types of extension are the most common ?
Why do you think multiple AM’s are required in a Transaction/Transactions?
Give me an example where this is applicable.
On any given OA Framework page, what is the sequence in which these methods will fire in a Controller?
A user clicks on a Submit button on a page. The fields on this page are attached to View Object attributes, which in turn are attached to Entity Object attributes. An exception is raised from validation EO due to data validation errors.
Tell me, which methods in controller will be fired when a Submit button is clicked on that page [assuming validations in EO throw an exception]
What are the steps to embed a custom region into a standard OA Framework page?
You have two OA Framework pages, page A and page B. Depending upon the value of a department selected in PageA, you wish to restrict the LOV of Approvers in page B.
How will you do this? Why would would not prefer to extend the viewObject of LOV?
What are different methodologies that you can consider to default value into a field?
What are different mechanisms of debugging in OA Framework.
From one controller, I wish to execute the code in other controller. Is it possible, and if yes, then how?
I wish to know the SQL statement of a View Object being used by a page. What is the quickest way to find out?
How would you deploy the BC4J extensions to the server?
I have extended the View Object and now I wish to locally test that extension in jDeveloper? Is that possible without loading the jpx file into the database?
When you run SQL Trace for an OA Framework session[using diagnostics], why are multiple *.trc files created on the database server?
How do you load XML page developed using jDeveloper?
Tell me two different methods you can use to get the XML Files of standard OA Framework pages.
Tell me two different methods you can use to get the XML definitions for standard OA Framework pages?
Please explain the different types of tasks you can do using Functional Administrator responsibility
Lets say a PageA has been personalized in Development and UAT environments. Is it possible to merge the personalizations done to same page in two different environments, using Functional Administrator?
What is the sequence of Personalizations override?
Where is dbc file located on the server? Is dbc file used by jDeveloper at RunTime or DesignTime?
By setting profile option “Disable Self Service Person%”, not only the personalization, but also
the OA Framework extensions get disabled. Please explain why?
How do you create User Level Personalizations?
Please explain the steps
Off the following levels in Personalizations, i.e. Responsibility Level, Site Level and Function level, which level has highest and least priority?
All above questions are very basic and practical in nature.
Any person applying for an OAF job should try to understand the concepts behind each of these questions.
Once you know the answer to these, I am confident that you can undertake a job of a Technical OA Framework Consultant.
PS- I have purposely not included any tricky/complicated questions, as complicated things can be learnt on the job itself
written by Bhupender Kumar , February 29, 2008
written by Rajender , March 01, 2008
written by Sri Ram , March 03, 2008
How to set responsibility context in OAF like fnd_global.APPS_INITIALIZE is used in database
written by Rohit.Monga , March 12, 2008
written by Rohit.Monga , March 17, 2008
written by Uday , March 18, 2008