Interview questions on OAF

1. What is the use of spel?
Ans :‐ We pass the dynamically value one page to another page and set the properties
dynamically.

2. Are you extend AM?
Ans:‐ yes , Root AM not suggestable to extends When it has contains LOV items Because Root
AM handles the sessions.

3. Types of VOs?
Ans:‐ 1. Simple VO
2. Entity based VO

4. What are the types of search pages?
Ans:‐ 1. Manual Search,
2. Automatic Search,→auto customization
3. Result Base Search→ResultBased


5. How insert the data?
Ans:‐ VO.Excequte Query();
Row row=vo.create row();
VO.Insert row(row);


6. How to Create the SUBMITT BUTTON in SeadedPage?
Ans:‐ By using Coextension write below code in
OASubmitButtonBean oasb = (OASubmitButtonBean) pageContext.getWebBeanFactory()
.createWebBean(pageContext, "BUTTON_SUBMIT");
OAAdvancedTableBean oatb =(OAAdvancedTableBean) webBean
.findChildRecursive("WOResultsTab");
oasb.setID("SubmitPrintButton");
oasb.setUINodeName("SubmitPrintButton");
oasb.setEvent("SubmitPrintButton");
oasb.setText("Click Here");
oatb.setFooter(oasb);
And set the id name ,node ,prompt by coding


7. How do you bounce the server?
Ans:‐ Inst Top
11i→we bounce APACHE Server
R12→we Bounce Both APACHE And OC4J Server
To bounce these server we need to run below shell scripts
11i
Stop server:‐sh $COMMON_TOP/admin/scripts/adapcctl.sh stop
Start server:‐sh $COMMON_TOP/admin/scripts/adapcctl.sh start
R12
Stop server:‐sh $INST_TOP/admin/scripts/adoacorectl.sh stop
Start server:‐ sh $INST_TOP/admin/scripts/adoacorectl.sh start



8. How do you debug for Custom Pages and Standard pages?
Ans :‐ Custom Pages
1. System.out.println("Message"+item);
         standard pages
1.OApageContext.Write Diagnostics
2 .Debug ‐‐‐‐‐Debug xml files only.


9. What are the Different procedures to pass the value one page to another page?
Ans:‐ Hash Map,
Destination URI→Page Path , Retain AM—>true ,ADD_BREAD_CRUMBS→Yes
AND (Pass the Attribute id(like Item _id and Header_id))


10. What is the diff B/W Table & Advance Table?
Ans:‐ Table Advanced Table
1.It contains row And Columns 1.Same as Table and
2. Rowspan
3. Column Span
4. column Grouping


11. Validation purpose which BC4J you will use for different scenarios why?
Ans :‐ EO and Coextensions based on Requirement.


12. What is the substitution? Where it is use?
Ans:‐ substitution will replace the old VO,EO and AM with the new(or)Extended VO,EO and
AM


13. What are the profile options did you use?
Ans:‐ FND Diagnostics→About the page we are use,
FND personalize self service definition,
FND personalize Region link Enabled,
FND personalize Document Root Path

14. In PageContext.Setforward URL(Retain AM→True
→False
And
ADD_BREAD_CRUMBS→yes
→No) what it shows?
Ans:‐ In PageContext.Setforward URL(Retain AM→True→Transfer the data Another page,
→False→Doesn’t Transfer the data another
page
And
ADD_BREAD_CRUMBS→yes→maintain the same URL total Project
→No→Doesn’t maintain the same URL total Project.


15. How to Disable the Button Seeded Page?
Ans:‐ Extended The CO and ofter
OAsubmittButtonBean mitt =( OAsubmittButtonBean)
WebBean.FindChaildRecursive(Cancel_button);→intialize the Button Bean
Mitt.SetDisable(True);


16.What is the diff B/W Viewlinks and Entity Associations?
Ans:‐ View links Entity Associations
1. Fetch the master details Data 1.Perform The DML operations

17. What are the diff B/W Fire Action ,Fire Partial Action AND Partial Page Rendering(PPR)?
Ans:‐ Fire Action Fire Partial Action Partial Page Rendering
1. Total page Refresh 1.Total page Refresh 1.perticular item Refresh
2. Cursor will be moved first position 2. Cursor at same position 2.It is used in dependent
poplist


18. What is dbc? What is the use?
Ans:‐ dbc means Database connection descriptior file and All the data base connection
information Available in this file .
Like HOST NAME:‐DB_HOST
PORT NUM:‐DB_PORT
SID:‐DB_NAME


19. HOW do you configure JDeveloper in local system?
Ans:‐ Go to Apps→About the page→Technology components→ OAFrame Work:‐12.1.1
Ofter→ Java System profile →Get dbc file path→ ofter download the Jdeveloper use Meta
link


20. What are the versions use in 11i and R12?
Ans:‐ 11i→ JDeveloper 9i,
R12→→ JDeveloper 10g→10.1.3.3.o


21. What is an entity object?
Ans:‐ Entity object is created based on a database table, it is responsible for
insertion/updation/validation of the table data. They are stored in the
oracle.apps.<prod>.<application>.schema.server package directory


22.What is an Application Module(AM)?
Ans:‐ Application module holds the related objects pertaining to an application ie. View
objects, Entity Objects etc. The application module helps in getting the required database
connection, maintains the page session or transaction context


23.What is the object passed to every page request?
Ans:‐ OAPageContext object is passed to every request, using this object the controller
initializes the application module object and will call the required methods.


24. How to call the Concurrent Program from OAF?
Ans:‐we need to know Concurrent Program(CP) CP name ,CP Parameters ,Application Name
We have submit Request method to call particular CP for that we need to add above
parameters.CP Parameters will be captured by Vector Class.
Vector is Collection when we want process more than one value


25. Diff B/W Call able statement and prepare statement?
Ans:‐ Callable statement prepare statement
Packages sql queries


26. How to move the personalization’s in one instance to another instance?
Ans:‐ Two methods are there 1.front end method
2.Back end method.
1. Front end method: ‐ Go to Functional Administrator→ Personalization’s→
Import/Export→ Personalization Repository/Exported personalization’s→
Select the Personalization file→Click on Export File system
We need to import Personalization into the instance
Import/Export→ Personalization Repository/Exported personalization’s→
Select the Personalization file→Click on import File system.
2. Back end method:‐
We need to find out the personalization path by using
Begin
Jdr_utils.list_customization(‘pagepath’);
End;
Run jradxml export script
Run JRADxml import script


27. How to call the one OAF page to another OAF page?
Ans:‐ 1.Pagecontext.Setforward URL(),
2. Pagecontext.Forward immediately (),
3. Pagecontext.send Redirect()
4.Destination URI:pagepath&reatinAM=Y&addBreadCrumb=Y&variablename={@Header
Id}


28. How to Create the Region in the Standard page?
Ans:‐we need to create a shared region in dummy workspace.
Eg: Region Style :Table
Create Table Region using wizard.
Go to Standard Page→add new item Style:‐ Stack Layout→extends:‐Region Path
Move all Class Files to
Run Import Script
For functionality of the Region we need to extend the CO.


29. How do you create the dependent pop list in standard page?
Ans:‐ In Process Request()
//Please attach PPR only to those UIX beans which support it //otherwise it may not work
OAMessageChoiceBean mcb=(OAMessageChoiceBean)webBean.findChildRecursive("");
FireAction firePartialAction = new FirePartialAction("empPositionChange");
mcb.setAttributeValue(PRIMARY_CLIENT_ACTION_ATTR,firePartialAction);
In Process Form Request
Write Dependent poplist code as in Custom Page


30. Extension Steps for VO?
Ans:‐ Download the page, AM, VO and CO.
Create the folder structure as per the page definition and create a dummy workspace and
with extending the VO, and add the required logic in the View Object, Attach it to the
Application Module and subsitute the VO with extended VO and run the XMLImporter script.


31. Extension Steps for EO?
Ans:‐ Process of extension is same and Extension is a combination of Substitution and
Personalization. If you have extended the BC4j component you have do the personalization


32. Extension Steps for CO?
Ans:‐ Process is same


33. Extension Steps for AM?
Ans:‐ Process is same


34. How to Enable the kff and dff?
Ans:‐


35. How to create the dependent LOV in page?
Ans:‐ eg:‐In Master LOV →Create Lov Map
LOV Map1
LOVRegion item:‐takes it table region attached to lov
Return Item:‐MasteLov ID name
Criteria Item: MasteLov ID name
LOV Map2
LOVRegion item:‐takes foreign key column from table region attached to lov
Return Item:‐Link
Criteria Item:none
Create an Item for Linking two LOV’S
Item style:form value
Item id:link
In Detail LOV →Create Lov Map
LOV Map1
LOVRegion item:‐takes it table region attached to lov
Return Item:‐DetailLOV ID name
Criteria Item: link

36. How to call the D2K form to OAF page?
Ans:‐String Destination = ”form : application_short_name :responsibility_key
:data_group_name :form_function_name”
pageConetext.forwardImmidiatlyTo Form(Destination)


37. How to Create the POP Ups without Java script?
Ans:‐ String page ="/sample/oracle/apps/po/hello/webui/SamplePG";
String URL = APPS_HTML_DIRECTORY + OAWebBeanConstants.APPLICATION_JSP + "?" +
OAWebBeanConstants . JRAD_PAGE_URL_CONSTANT + "=" +Page +"&retainAM=Y";
OAButtonBean Button = (OAButtonBean)webBean.findChildRecursive("button on click u
want to open window");
OABoundValueEmbedURL sample = new OABoundValueEmbedURL(Button , "
openWindow(self, '", URL, "' , 'longTipWin', {width:"1000",
height:"500",top:250,left:250,resizable:0}, true); return false;");
Button.setAttributeValue(oracle.cabo.ui.UIConstants.ON_CLICK_ATTR, sample );


38. What are the API’s uses in OAF?
Ans:‐ Fnd_User_Pkg.Disable user,
Fnd_User_Pkg.Enable user etc…..


39.What are the diff B/W inline LOV & External LOV?
Ans:‐Inline LOV will be used only single page.
External Lov can be used anywhere in the project.
LOV Item→extnds:‐path of external Lov Item.


40. PPR follows GET or POST flow?
Ans:‐POST flow


41. What are the methods in controller?
Ans:‐ Process data ,process form request, process request


42. How to add the columns in EO in seeded page?
Ans:‐ Extended the EO and Ofter the synchronize the EO


43. How to add the columns in EO in Custom page?
Ans:‐Delete all the data from the table and alter the table by adding new columns.
And then Synchronize with Database on EO


44. What is MVC Architecture?
Ans:‐ Architecture means set of rules and services called architecture
MVC:‐ model view controller
Model:‐ All the data base transaction called model.
Like→Tables,Synonyms,PL/SQL procedures,functions….etc
View:‐Display the OAF output called view and also called USER INTERFACE.
Controller:‐ The output When you Want Display called Controller


45. What is process form data?
Ans:‐ If the exception are thrown During the process request and process form request it will
skip those methods & process form data will execute.


46. What is BC4J?
Ans:‐ BC4J is the directive structure the of the apps. Where all the objects will be reside.


47. What are the MDS tables?
Ans:‐ JDR_PATHES,
JDR_COMPONENTS,
JDR_ATTRIBUTES


48. How many types of AM’s which those are used?
Ans:‐ Two types of AM’s 1.Root AM
2. Nested AM
Root AM:‐ Attaching the AM to the Root region is called Root AM.
Nested AM:‐ Attaching the AM to the Nested regions called Nested AM.


49. What is the different B/W Vorowimpl and Voimpl?
Ans:‐ Vorowimpl:‐ Refer the single row
Voimpl :‐ Collection of records


50. I have 5 pages are there how to know I am in which page?
Ans :‐ By using train concept.
Steps→ create 3 pages
2.create the External(shared)Region style as TRAIN → create link for each page →in
each link give page path
3.create the External(shared)Region style as PageButtonbar→ under navigation Bar
create link for each page →in each link give page path and Text for each page
4.In each page create the location in the page region and set the properties:‐
1.extends→Browse project file→press search button→Press ok
2.Allow inter action →True
5.In page create the new region style as Page button bar→extends→ Browse project
file→press search button→press k


51. Where does the two categories of files in OAF be placed in the server?
Ans:‐ All the xml files of the page/region will be placed in the respective TOP’s mds directory.
All the class files irrespective of TOP will be placed under $JAVA_TOP which can be
$COMMON_TOP/java


52. In 11i to R12 migrate which BC4J causes problems?
Ans:‐ AM


53.When is the processRequest method called?
Ans:‐ PR method is called when the page is getting rendered onto the screen


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


55. When you get null pointer exception?
Ans:‐Suppose you want to get any value from page to refer any value that value is
representing as null then null pointer exception should pop up.


56. How to register the page in apps?
Ans:‐ Told in the sessions as like form we have to do


57. After doing the personalization/Extension in seeded Page rename the page and how to
add the Respective responsibility?
Ans: Told in the sessions as like form we have to do


58 .Steps for creation of the page?
Ans:‐ 1.Create the tables from as for the client requirement
2.Create the New work space after that create the project Name:‐ name
Default Project Name:‐oracle.apps.po.requision.webui
3.After that create the page name:xxxPG
4.Crate the Applicationmodule AM
Packagenaeme:‐ XXXXXXX.oracle.apps.po.emaxcusterebate.server
Name:‐xxxxAM
5.After that give Attach the Am to the region and give the WINDOW TITLE:‐
TITLE