How do you migrate layout or data template across instances?

Oracle Apps Interview Questions › Category: XML Publisher › How do you migrate layout or data template across instances?

0 Vote Up Vote Down

Questions Master asked 9 years ago

1 Answers

0 Vote Up Vote Down

Shailender Thallam Staff answered 9 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