How do you migrate layout or data template across instances?

Oracle Apps Interview QuestionsCategory: XML PublisherHow do you migrate layout or data template across instances?
Questions Master asked 3 years ago
1 Answers
Shailender Thallam Staff answered 3 years ago

We can use XDOLoader utility to migrate both data template and layout. Below is the example:
 
Data Template:

      java oracle.apps.xdo.oa.util.XDOLoader UPLOAD \
      -DB_USERNAME ${apps_user} \
      -DB_PASSWORD ${apps_pwd} \
      -JDBC_CONNECTION ${TNS_STRING} \
      -LOB_TYPE DATA_TEMPLATE \
      -APPS_SHORT_NAME XXCUST \
      -LOB_CODE XX_DT_REPORT \
      -LANGUAGE en \
      -TERRITORY US \
      -XDO_FILE_TYPE XML \
      -NLS_LANG ${NLS_LANG} \
      -FILE_CONTENT_TYPE ‘text/html’ \
      -FILE_NAME XX_DTEMPLATE.xml \
      -LOG_FILE XX_DTEMPLATE.xml.log \
      -CUSTOM_MODE FORCE
      FIN_STATUS=$?
 
Layout:

      
  java oracle.apps.xdo.oa.util.XDOLoader UPLOAD \
  -DB_USERNAME ${apps_user} \
  -DB_PASSWORD ${apps_pwd} \
  -JDBC_CONNECTION ${TNS_STRING} \
  -LOB_TYPE TEMPLATE_SOURCE \
  -APPS_SHORT_NAME XXCUST \
  -LOB_CODE XX_DT_REPORT \
  -LANGUAGE en \
  -TERRITORY US \
  -XDO_FILE_TYPE RTF \
  -NLS_LANG ${NLS_LANG} \
  -FILE_CONTENT_TYPE ‘application/rtf’ \
  -FILE_NAME XX_LAYOUT.rtf \
  -LOG_FILE XX_LAYOUT.rtf.log \
  -CUSTOM_MODE FORCE