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

How to find the responsibility name and key in Oracle apps:

SELECT unique r.responsibility_key,responsibility_name,
fa.application_short_name
FROM apps.fnd_user u,
apps.fnd_user_resp_groups ur,
apps.fnd_responsibility r,
apps.fnd_application_tl a,
apps.fnd_application fa,
apps.fnd_responsibility_tl tl
WHERE 1=1
AND ur.responsibility_id = r.responsibility_id
AND ur.responsibility_id = tl.responsibility_id
AND u.user_id = ur.user_id
AND fa.application_id = a.application_id
AND r.application_id = a.application_id
AND u.user_name = UPPER(:user_name)
and tl.language ='US'
ORDER BY 1