Oaf Page deployment

Steps to Deploy OAF page into APPS
---------------------------------------

1.) In Jdeveloper compile the page.
    When page got compiled, it will create .class files for all our java files.
    java files and xml files ->  Jdeveloper installed place\jdevhome\jdev\myprojects
    class files              ->  Jdeveloper installed place\jdevhome\jdev\myclasses
 
2.) Java Files can also be compiled in UNIX.
    Go to JAVA_TOP(/u01/oracle/DEMO/apps/apps_st/comn/java/classes).

3.) In JAVA_TOP copy your package structure of myprojects (eg:  xxxx/oracle/apps/per/selfservice/server, xxxx/oracle/apps/per/selfservice/webui)

4.)Compile each Java file.
   eg. xxxx/oracle/apps/per/selfservice/server
 
        xx_paymentsVOImpl.java
     
        javac xx_paymentsVOImpl.java  -> To compile java file.

5.)Continue this process for all java files.

6.) Run your import script for pages and regions.

7.)Import script should be run in webui(xxxx/oracle/apps/per/selfservice/webui)

8.)Go to xxxx/oracle/apps/per/selfservice/webui in UNIX
   and run below Import script.
 
   java oracle.jrad.tools.xml.importer.XMLImporter $JAVA_TOP/xxxx/oracle/apps/per/selfservice/common/webui/PayslipPG.xml -username apps -password appsdemo -dbconnection "(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=tcp)(HOST=host address)(PORT=portno)))(CONNECT_DATA=(SID=DEMO)))" -rootdir $JAVA_TOP

 
9.)Import scrip can also be run from our cmnd prompt, check it in Google once.

10.) Print Documents to check imported XML page content (Optional)

     Example –

     DECLARE

     BEGIN

     jdr_utils.printDocument('/prajkumar/oracle/apps/fnd/webui/HelloWorldPG',1000);

     EXCEPTION

     WHEN OTHERS THEN

     DBMS_OUTPUT.PUT_LINE(SQLERRM);

     END;
   
11.) Create a Function(Application Developer->Applicaton->Function)
     In Properties -> select Type      = SSWA JSP Function
     In WEBHTMl    -> select HTML Call = OA.jsp?page=/xxxxx/oracle/apps/per/selfservice/common/webui/PayslipPG
   
12.) Create a Menu and submenu.Attach this Function to sub menu and submenu to menu.
     Attach menu to Responsibilty and run the page.


PagePath: XXSpel/oracle/apps/po/requisition/webui/XXSpelPG.xml


RespName: XXEppsysPracticeResp

Menu : OAFPAGES

Employee Data   Employee Data Function
DbOafPages      OAFForm

XXEMPLOYEEINFO

OA.jsp?page=XXSpel/oracle/apps/po/requisition/webui/XXSpelPG


OA.jsp?page=XXGetEMPData/oracle/apps/po/EmpData/webui/XXEmpDataPG.xml


java oracle.jrad.tools.xml.importer.XMLImporter $JAVA_TOP/XXGetEMPData/oracle/apps/po/EmpData/webui/XXEmpDataPG.xml - username apps -password appsdemo -dbconnection "(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=tcp)(HOST=host address)(PORT=portno)))(CONNECT_DATA=(SID=DEMO)))" -rootdir $JAVA_TOP


Employee Data Function



Server bouncing

Bounce the server:
====================

Go to the custom path where class file is present

run adcgnjar

Bounce the oacore

cd $ADMIN_SCRIPTS_HOME
/*
./admanagedsrvctl.sh stop oacore_server1

./admanagedsrvctl.sh start oacore_server1

*/

Bounce the apache

./adapcctl.sh stop

./adapcctl.sh start