• 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
    • Oracle database
    • Oracle Ebusiness Suite
    • Oracle weblogic
    • Oracle Performance Tuning
    • Oracle Hyperion
    • Oracle Cloud Tutorials
  • SQL
  • interview questions
  • Linux
  • PHP and HTML
  • Downloads
  • General
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

Primary Sidebar

Top Posts & Pages

  • Oracle Indexes and types of indexes in oracle with example
  • Top 30 Most Useful Concurrent Manager Queries
  • Top 46 Oracle ASM Interview Questions
  • Oracle dba interview questions and answers
  • 40 question you must know about R12.2



Subscribe to our mailing list

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

Recent Posts

  • Multi Language Support in 11i/R12
  • EBS PDB service name disappear from listener in 19c
  • how to download oracle e-business suite 12.2 software
  • Step by step upgrade process to R12.2 Upgrade part -2(Main Upgrade Driver for R12.2.0)
  • Step by step upgrade process for R12.2 Upgrade Part -1

Copyright © 2021 : TechGoEasy

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