Wednesday, 30 July 2014

REGISTRATION OF OAF PAGE IN APPS.


Now we are going to learn about how to register the pages in apps.

First create the page in JDeveloper and compile the page.

After compiling the page now we have to move the class files to Java top in server.

Step1:-Move the class file from local machine  to $java top

local machine path:-   <JDeveloper patch directory>/jdevhome/jdev/myclasses  
the class file is located in this folder move that to

Server path:-   /oracle/apps/r12/visr12/apps/apps_st/comn/java/classes
Move the whole folder where your project located.

Here I am using WinSCP tool to move the files.





Step2:- XML import utility

            After moving the files to the server we to import the xml files.
Open the command prompt.

change the directory to:-     C:\dev\oaf\jdevbin\oaext\bin
                                               

after that import the following:-
make the fallowing path in a single line for that in notepad go format uncheck word wrap:-

import C:\dev\oaf\jdevhome\jdev\myprojects\sangu\oracle\apps\po\searchPRJ\webui\SearchPG.xml -rootdir C:\dev\oaf\jdevhome\jdev\myprojects -username apps -password apps -dbconnection "(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=ebsr12.com)(PORT=1521))(CONNECT_DATA=(SID=visr12)))"

NOTE
C:\dev\oaf\jdevhome\jdev\myprojects\sangu\oracle\apps\po\searchPRJ\webui\SearchPG.xml
(This is the path where the oaf pages stores in our local machine)

Give the proper username, password, host name, port name, db name)

From unix server:

Run the below command from the path.

$JAVA_TOP/sangu/oracle/apps/po/searchPRJ/webui

java oracle.jrad.tools.xml.importer.XMLImporter $JAVA_TOP/sangu/oracle/apps/po/searchPRJ/webui/SearchPG.xml -rootdir  $JAVA_TOP -username apps -password apps -dbconnection "(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=focusthreadr12.com)(PORT=1521))(CONNECT_DATA=(SID= VISR12)))"
 

Step3:- Login to Oracle Apps

                Switch to Application Developer Responsibility Select Function.

            Application Developer--- > Function

                Create a function

Name:-               (EMP_SEARCH)

            User Function Name:-    (EMP_SEARCH)




After that go to Properties tab and select as

Type:- SSWA jsp function






Next Go to Web HTML tab and give the path of your page

HTML Call:- OA.jsp?page=/sangu/oracle/apps/po/searchPRJ/webui/SearchPG




Save  and exit.


Step4:- Create a menu-attach the function

Application Developer--- > Menu

Provide the following details.

Menu:-  (SANGU_EMP)

            User Menu Name:- (SANGU_EMP)

            Menu Type:- Standard.

Next give :-

                Seq:-

                Prompt:-   (Emp Search)

                Function:- EMP_SEARCH (Give the function Name u have created).





Step5:-Crete the Responsibility and attach the menu.

                System Administrater-- >Security-- >ResponsibilityàDefine.
               
Provide the following

                Responsibility Name:-  (Sangu_OAF)

                Application:-Purchasing.

                Rsponsibility Key :- (SANGU_OAF)

                MENU :- SANGU_EMP (Select the menu that u have created)
               

DataGrup
                Name:-Standered

                Application:- Purchasing.


            




Step6:-Attach the responsibility to user.

            System Administrater-- >Security-- >User -- >Define.

                




This finishes the registration Switch to the responsibility u created .

U will see the page.




No comments:

Post a Comment