Import Script in OAF

  • Share this blog:

In this lesson, we are going to see the import script in OAF and how to use the import script in oaf.

The importance of the OAF import script is for the redirection of pages into the MDS directory.

Let us consider in our project we have one OAF page with the following page link generated:


 so for the above search page see the following import script which we need to perform in putty:

java $JAVA_TOP/xxstirling/oracle/apps/po/stirlingprj/webui/SearchPG.xml -username apps -password apps -dbconnection "(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=tcp)(" -rootdir $JAVA_TOP

 the above import script is for linux/unix environment but few students might practice in Windows server environment for them the following is the import script for window server environment:

import D:\Bharath\Softwares\p9879989_R12_GENERIC\jdevhome\jdev\myprojects\xxstirling\oracle\apps\po\stirlingprj\webui\SearchPG.xml -rootdir ...(your win server apps rootdir)..\jdevhome\jdev\myprojects -username apps -password apps -dbconnection "(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=tcp)("

For every page we need to execute the import script in OAF, the below image shows the import script execution process, i.e., after writing the import script the following is the confirmation it shows in putty:

Whenever the import script is executed successfully, i.e., if the importing file is properly executed then it shows a message called “Import Completed”. 


$ java $JAVA_TOP/xxstirling/oracle/apps/po/stirlingprj/webui/SearchPG.xml -username apps -password apps -dbconnection "(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=tcp)(" -rootdir $JAVA_TOP

Starting XML Importer at Mon Oct 25 13:47:08 CDT 2021 ...
XMLImporter: Release 11.1.1
(c) Copyright 1999, 2010 Oracle Corporation
All rights reserved.
Import file: /xxstirling/oracle/apps/po/stirlingprj/webui/SearchPG.xml
Parsing Import file: /xxstirling/oracle/apps/po/stirlingprj/webui/SearchPG.xml
Import Directory: /u01/APPS/visappl/fnd/11.5.0
Log file directory: /u01/APPS/visappl/fnd/11.5.0/patch/115/import/log
ADI Mappings directory: /u01/APPS/visappl/fnd/11.5.0/patch/115/import/adi
ADI Scripts directory: /u01/APPS/visappl/fnd/11.5.0/patch/115/import/adi/scripts
Executing Oracle file: /u01/APPS/visappl/fnd/11.5.0/patch/115/sql/AFSCHEM.sql
Log file for this execution is located at: /u01/APPS/visappl/fnd/11.5.0/patch/115/import/log/AFSCHEM.log
Completed execution of Oracle file: /u01/APPS/visappl/fnd/11.5.0/patch/115/sql/AFSCHEM.sql
Import Completed

In the next lesson, we are going to see how to create a function, creating a menu, and attaching a menu to Responsibility.


Check out our Related Blogs:

You liked the article?

Like : 0

Vote for difficulty

Current difficulty (Avg): Medium

Recommended Courses


About Author
Author Bio

TekSlate is the best online training provider in delivering world-class IT skills to individuals and corporates from all parts of the globe. We are proven experts in accumulating every need of an IT skills upgrade aspirant and have delivered excellent services. We aim to bring you all the essentials to learn and master new technologies in the market with our articles, blogs, and videos. Build your career success with us, enhancing most in-demand skills in the market.