25 October, 2018
In this lesson, we are going to see the import script in OAF and how to use import script in oaf.
The importance of OAF import script is for redirection of pages into 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 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 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”.
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 Popular Trainings Structure of OAF Advantages and Dis-Advantages of OAF SQL Server DBA Training in Dallas Creating First OAF Page in Project