• Skip to primary navigation
  • Skip to main content
  • Skip to primary sidebar
Techgoeasy

Techgoeasy

Learn Oracle, PHP, HTML,CSS,Perl,UNIX shell scripts

  • Home
  • Oracle database
  • Oracle Ebusiness Suite
  • Oracle weblogic
  • Oracle Performance Tuning
  • Oracle Hyperion
  • Oracle Cloud Tutorials
  • SQL
  • interview questions
  • Linux
  • PHP and HTML
  • Downloads
Home » Oracle » how to use XMLImporter and FndXdfCmp in Oracle EBS

how to use XMLImporter and FndXdfCmp in Oracle EBS

August 12, 2019 by techgoeasy Leave a Comment

XMLImporter and FndXdfCmp are the implement utilities in Oracle E business Suite for implementing new OAF pages and new schema definition and changes

XMLImporter is used for new OAF pages and personilization in the oracle database while FndXdfCmp is used for new schema definition and changes

Here are the steps on how to use XMLImporter and FndXdfCmp

XMLImporter

Syntax
java oracle.jrad.tools.xml.importer.XMLImporter <dir_path>/<file_name>.xml 
-username <user_name> -password <password> 
-dbconnection "(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=<host_name>)(PORT= <port_number>)) (CONNECT_DATA=(SID=<database_sid>)))" 
-rootdir <dir_path> -rootPackage <package>
Examples
java -classpath "${CLASSPATH}" oracle.jrad.tools.xml.importer.XMLImporter $APPL_TOP/ahl/12.0.0/mds/prd/webui/WorkorderDetailsRN.xml -username apps -password apps -dbconnection "(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=exam.com)(PORT=1521))(CONNECT_DATA=(SERVICE_NAME=TEST)))" -userId "1" -rootPackage /oracle/apps/ahl -rootdir $APPL_TOP/ahl/12.0.0/mds

java -classpath "${CLASSPATH}" oracle.jrad.tools.xml.importer.XMLImporter    $APPL_TOP/ahl/12.0.0/mds/prd/webui/WorkorderDocumentsRN.xml -username apps -password apps -dbconnection "(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=exam.com)(PORT=1521))(CONNECT_DATA=(SERVICE_NAME=TEST)))" -userId "1" -rootPackage /oracle/apps/ahl -rootdir $APPL_TOP/ahl/12.0.0/mds

Importing file "/u01/oracle/TEST/apps/apps_st/appl/ahl/12.0.0/mds/prd/webui/WorkorderDocumentsRN.xml" as "/oracle/apps/ahl/prd/webui/WorkorderDocumentsRN".

Import completed.

FndXdfCmp


FndXdfCmp is a Java Utility which is located under the $JAVA_TOP/oracle/apps/fnd/odf2 which is used to verify and create Database Objects, defined in a xdf-File
Syntax

FndXdfCmp

Possible Object Types are :
Oracle table, mview, Oracle view, synonym, Oracle index, trigger, comment, context, mviewlog, qtable, sequence, type, queue, policy, all

Mandatory Arguments :

Oracle_Schema : ORACLE schema name of the EBS module in which the object exists or should be created, e.g. FND, AD, GL, MFG.
Oracle_Password : ORACLE schema password of EBS module.
apps_schema : ORACLE Schema name of current APPS schema.
apps_password : ORACLE schema password of current APPS schema.
jdbc_protocol : JDBC driver type / protocol (thin or oci8).
JDBC_Connect_String : The JDBC connection string to connect to the Database. It must include the ::
object_type : The object type to be maintained / created – table, qtable, mview, mviewlog, sequence, type, trigger, view, policy
xdf_fileName : The xdf file name containing the object definition.
xsl_directory : The xsl directory having all the xsl files required for XSLT transformation. Normally its $FND_TOP/patch/115/xdf/xsl or $FND_TOP/admin/xdf/xsl.

Example
adjava "-mx128m" "-nojit" "oracle.apps.fnd.odf2.FndXdfCmp" "applsys" "apps" "apps" "apps" "thin" "(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=exam.com)(PORT=1531))(CONNECT_DATA=(SERVICE_NAME=TEST)))" "type" " fnd_usr_roles.xdf " "$FND_TOP/patch/115/xdf/xsl"

Related Articles

ADODFCMP Utility
FNDLOAD command
FNDCPASS and AFPASSWD
ADMRGPCH

Filed Under: Oracle, Oracle Ebuisness Suite Tagged With: FndXdfCmp, XMLImporter

Reader Interactions

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

Primary Sidebar



Subscribe to our mailing list

Enter your email address to subscribe to this blog and receive notifications of new posts by email

Recent Posts

  • How to clone Oracle Home in 10g/11g/12c/19c/23c
  • How to find the FND_FILE output of the running concurrent request
  • srvctl commands in Oracle
  • Top SQL Patch Queries in Oracle Database
  • how to find if the sql is using the SQL Patch

Copyright © 2023 : TechGoEasy

  • Hire me
  • Privacy Policy
  • Contact Us
  • New? Start Here
  • About Us