Hi Friends,

Today I am going to share how to start learn ADF.

Open your Jdevloper.

Click on New application.

 
Click on Ok and complete 5 steps(Just click next).And finally click on finish.

Here we can see Two projects one is for Model components and another one is for ViewController.
Just click on next and complete the entire wizard.
Now it is a time to creating Model Components.
In earlier version like in OAF model components are bc4j and now ADF Business components.
Step 1: Right Click on Model Components and Create ADF Business components.



                                       

OAF Interview Questions:

1)Explain About MVC Architecture.

Ans: MVC means model,view and controller structure.

Here user interface will be consider as View(UI) in OAF we have UI in XML format.
Controller will capture the user actions and interact with model components.In OAF we have controller as a java class consists of three methods.

Process Request:
Before page loading if you want perform any activity need to write a code in this method.

Process Form Data:
It handle the data flow on page.

Process Form request:
if you want perform any activity based on events/fire actions need to write a code in this method.

coming to model :it will interact with database below objects will consider as model components.
Application Module:It will establish the data base connection.
Handle the transactions like commit and roll back.

2)How to roll back page if some one deleted page from application server ?

You can get the same page from MDS using JDR_UTILS.PRINTDOCUMENT('<page name with location>');

3)How find the page information and version ?

enable FND_DIAGNOSTICS,FND_PRES%SELF%SERVICE% profile options using sysadmin responsibilty.

It will enable the About this page link and personalization link.
Go to About this page and click on page context tab.
here you will find the DBC file name and version details.

4)How to delete the customizations in OAF?

First get the customizations on page using :

JDR_UTILS.LISTCUSTOMIZATIONS('<page name with location>'); 

Delete the customizations using below API.

JDR_UTILS.DELETEDOCUMENT('<page name with location>');

5)explain the deployment steps from local system to server ?

How to display popup in OAF:

StringBuffer l_buffer = new StringBuffer();
l_buffer.append("javascript:window.onbeforeunload(YOUR POP UP)");
pageContext.putJavaScriptFunction("Name",l_buffer.toString());

Importing VO substitution using Unix script:

java oracle.jrad.tools.xml.importer.JPXImporter /<location of file><name of object.jpx> -username apps -password APPS#NES1 -dbconnection "(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(Host=<>)(Port=<>)) (CONNECT_DATA=(SERVICE_NAME=<>)))"

Page import:

java oracle.jrad.tools.xml.importer.XMLImporter <Page location> -username apps -password apps -dbconnection "(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST= <>)(PORT=<>))(CONNECT_DATA=(SID=<>)))" -rootdir $JAVA_TOP

Import page from cmd prompt:

import from cmd:

import D:\<page name >xml -rootdir D:\OAF\jdevhome\jdev\myprojects -username apps -password apps -dbconnection "(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=<>)(PORT=<>))(CONNECT_DATA=(SID=<>)))"

from unix :

java oracle.jrad.tools.xml.importer.XMLImporter $JAVA_TOP/<> -username apps -password apps -dbconnection "(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST= <>)(PORT=<>))(CONNECT_DATA=(SID=<>)))" -rootdir $JAVA_TOP

Basics of purchase order  in oracle apps R12:

To create a PO we need below set-ups :

1)Create a User
2)define person
3)assign job
4)Assign manger if needed
5)assign above person in FND user
6)define buyer from purchasing responsibility
7)Check the approval assignment
8)check the approval group for above approval assignment
9)open purching periods
10)open GL and inventory periods
11)check Owner Can Approve  flag in setups -->document types and click on update symbol

How to find the concurrent program name from request Id:



SELECT DISTINCT a.request_id, c.USER_CONCURRENT_PROGRAM_NAME,round(((sysdate-a.actual_start_date)*24*60*60/60),2) AS Process_time,
a.request_id,a.parent_request_id,a.request_date,a.actual_start_date,a.actual_completion_date,(a.actual_completion_date-a.request_date)*24*60*60 AS end_to_end,
(a.actual_start_date-a.request_date)*24*60*60 AS lag_time,d.user_name, a.phase_code,a.status_code,a.argument_text,a.priority
FROM
apps.fnd_concurrent_requests a,apps.fnd_concurrent_programs b,apps.FND_CONCURRENT_PROGRAMS_TL c,apps.fnd_user d
WHERE
a.concurrent_program_id=b.concurrent_program_id
AND b.concurrent_program_id=c.concurrent_program_id
AND a.requested_by=d.user_id
and a.request_id ='131645275'
order by Process_time desc;

To get the name of service :

select class_name, irep_name, class_type, class_id
from apps.FND_IREP_CLASSES
where irep_name like '%Purchase%';

SELECT ff.TYPE, ff.irep_method_name, fif.function_id, ff.function_name, fic.class_name, irep_name, fif.description
FROM fnd_form_functions_vl ff, fnd_irep_function_flavors fif, fnd_irep_classes fic
WHERE 1 = 1

AND fif.function_id = ff.function_id
AND ff.irep_class_id = fic.class_id
AND function_name LIKE 'PLSQL%UPDATE_PERSON_ADDRESS'
AND (irep_name LIKE 'HR%' OR irep_name LIKE 'PER%' OR irep_name LIKE 'PAY%')
ORDER BY 4
The below script would list down all HRMS APIs of PLSQL type and their mandatory parameters, this can be used to build the basic skeleton for your custom wrapper programs.

SELECT irep_name || '.' || ff.irep_method_name api, fp.param_name, fp.param_direction,
fp.param_optional, fp.DEFAULT_VALUE, fp.parameter_type
FROM fnd_form_functions_vl ff,
fnd_irep_function_flavors fif,
fnd_irep_classes fic,
fnd_parameters fp
WHERE 1 = 1
AND fif.function_id = ff.function_id
AND ff.irep_class_id = fic.class_id
AND function_name LIKE 'PLSQL%'
AND (irep_name LIKE 'HR%' OR irep_name LIKE 'PER%' OR irep_name LIKE 'PAY%')
AND fp.function_id = ff.function_id
AND param_optional = 'N'
ORDER BY 1, param_sequence