Import Script in OAF

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:

OA.jsp?page=/xxstirling/oracle/apps/po/stirlingprj/webui/SearchPG

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

java oracle.jrad.tools.xml.importer.XMLImporter $JAVA_TOP/xxstirling/oracle/apps/po/stirlingprj/webui/SearchPG.xml -username apps -password apps -dbconnection "(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=tcp)(HOST=www.newtonapples.com)(PORT=1521)))(CONNECT_DATA=(SERVICE_NAME=vis)))" -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)(HOST=www.newtonapples.com)(PORT=1521)))(CONNECT_DATA=(SERVICE_NAME=vis)))"

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 oracle.jrad.tools.xml.importer.XMLImporter $JAVA_TOP/xxstirling/oracle/apps/po/stirlingprj/webui/SearchPG.xml -username apps -password apps -dbconnection "(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=tcp)(HOST=www.newtonapples.com)(PORT=1521)))(CONNECT_DATA=(SERVICE_NAME=vis)))" -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:

• Structure of OAF
• Advantages and Dis-Advantages of OAF
• SQL Server DBA Training in Dallas
• Creating First OAF Page in Project