Saturday, July 11, 2009

Deploying OAF Pages in Oracle Application

How to deploy OAF Pages in Oracle Application :-
The steps in brief are :
· Development of the OAF Page in local machine
· Transferring the related source code/files to the Oracle APPS environment.
· Importing the new directory structure/path of the page/form in the MDS repository
· Registration Page in the Oracle Apps environment

1.Development of OAF Page Files in Local host:

I’ve developed the Search page in Myprojects of jdevhome/jdev folder.

I’ve kept my xml pages in webui (i.e. jdevhome/jdev/myprojects/xxat/oracle/apps/search/webui) and EO, VO and AM in server folder of the
project folder (i.e. jdevhome/jdev/myprojects/xxat/oracle/apps/search/server).

On project compilation the class files along with xml files are generated in Myclasses of
jdevhome/jdev/myclasses folder.

The Folder Structure for xml pages and respective Controllers are as below
C:\JDeveloper\jdevhome\jdev\myclasses\xxat\oracle\apps\search\webui

Similarly, the server folder structure is as below

C:\JDeveloper\jdevhome\jdev\myclasses\xxat\oracle\apps\search\server

2.Transferring the related source code/files to the Oracle APPS environment

The next step will be to move the files into the JAVA_TOP.

Transferring To Java_Top:

Through FTP we can easily move our files into Java_top folder.
we have to transfer the xxat folder from our local machine(C:\JDeveloper\jdevhome\jdev\myclasses\xxat) to application server

Path : $JAVA_TOP

So now we are done with transfers.

3.· Importing the new directory structure/path of the page/form in the MDS repository

Importing the XML files:
Run the import scripts for the PG and LOVRn files.
The import command is
import
C:\JDeveloper\jdevbin\oaext\bin>import C:\JDeveloper\jdevhome\jdev\myprojects\xxat\oracle\apps\search\webui\XxAtSearchPG.xml -rootdir C:\JDeveloper\jdevhome\jdev\myprojects -username -password -dbconnection "(DESCRIPTION =(ADDRESS_LIST =(ADDRESS = (PROTOCOL = TCP)(HOST = )(PORT = )))(CONNECT_DATA = (SERVER = DEDICATED) (SID =)))"

The command is to be run from Command Prompt.
the output you will see is :- Import completed

4.Registration Page in the Oracle Apps environment

Registering the Main Page as a function
1.Open Oracle Application
2. Go to System Administrator Responsibility
3. Click on Function Menu
4(a).Enter the Function Name
4(b).User Function Name
4(c).Description
4(d).Enter Properties (Tab) Type as SSWA jsp function
4(e).In Web HTML(tab)
Enter the Main xml page path
ahlchrome.jsp?page=/xxat/oracle/apps/search/XxAtSearchPG
(Don’t append .xml with the path, it results in error)
5.Attach the function with a menu and then run from the respective responsibility.

  • Bounce the Apache server
  • Run the page from menu – function in Apps
You are Done With the deployment.

---Simplifying O.A.Framework---

10 comments:

  1. Thanks Nitin for your article yesterday it was really a life saver for me..i had to deploy my oaf pages but was getting problem in deployment..googled a lot and found ur article..i tried once as per the artical and here it worked in one go..thanks to u for writing such a compact and informative steps.

    keep writing..looking ahead more from u..

    Thanks
    Renu

    ReplyDelete
  2. thank you Nitin for helping me to transform into a developer after sveral years of hard work as a DBA.

    ReplyDelete
  3. hi,
    pls help , i need
    Importing the new directory structure/path of the page/form in the MDS repository
    for linux machine

    ReplyDelete
  4. Nice to See your Blog nitin..keep it up buddy..written really nice articles..!!

    ReplyDelete
  5. Hi Nitin,
    Its really great to see your site..From now onwards will dusturb you for any kind of OAF help required.
    PAPIYA

    ReplyDelete
  6. TekSlate is the reputed e-learning tutorial across the globe delivers brief understanding about oaf in oracle oaf free tutorial with advanced teaching methodologies

    To Learn More Follow Below Link:
    http://bit.ly/1yJXoH8

    ReplyDelete
  7. Hi,
    I have a error when i click on the custom function :
    You have encountered an unexpected error. Please contact the System Administrator for assistance.

    ReplyDelete
  8. Nice learning thanks for inputs .

    Request for more details live examples that will help and also issues you faced.

    ReplyDelete