XML/BI Publisher Template/Report Migration UNIX Scripts

Here are the simple steps to migrate BI Publisher Report objects ( Data Defn, Layout Template, Concurrent Programs etc ) from one instance to another instance.

Downloading from Environment

• Download Data Template/Layout template metadata defn into file .ldt

FNDLOAD apps/ apps 0 Y DOWNLOAD $XDO_TOP/patch/115/import/xdotmpl.lct <Defn_Name>.ldt XDO_DS_DEFINITIONS APPLICATION_SHORT_NAME=<Custom_Application> DATA_SOURCE_CODE=<DataDefn_Code> TMPL_APP_SHORT_NAME=<Custom_Application> TEMPLATE_CODE=<TemplateDefn_Code>

• Download Concurrent Program defn into file .ldt

FNDLOAD apps/apps 0 Y DOWNLOAD $FND_TOP/patch/115/import/afcpprog.lct <Conc_prog_name>.ldt PROGRAM CONCURRENT_PROGRAM_NAME=<Conc_Prog_Name> APPLICATION_SHORT_NAME=<Custom_Application_Name>

• Download the Layout template physically from the instance. Please note after the command is run successfully output will be the file stored in the current directory from where the command is run.

java oracle.apps.xdo.oa.util.XDOLoader DOWNLOAD \

-DB_USERNAME apps \

-DB_PASSWORD apps \

-JDBC_CONNECTION pra.host.com:1527:<SID> \

-LOB_TYPE TEMPLATE \

-APPS_SHORT_NAME <Custom_Application> \

-LOB_CODE <TemplateDefn_Code> \

-LANGUAGE en \

-TERRITORY US

• Download the data template physically(If you have one) from the instance. Please note after the command is run successfully output will be the file stored in the current directory from where the command is run.

java oracle.apps.xdo.oa.util.XDOLoader DOWNLOAD \

-DB_USERNAME apps \

-DB_PASSWORD apps \

-JDBC_CONNECTION pra.host.com:1527:<SID> \

-LOB_TYPE DATA_TEMPLATE \

-APPS_SHORT_NAME <Custom_Application> \

-LOB_CODE <DataDefn_Code> \

-LANGUAGE en \

-TERRITORY US

COPY THE FILES TO THE TARGET ENV USING FTP AND THEN UPLOAD.

Uploading to an Environment

• Upload AOL Defn of Data/Layout templates and the Concurrent program using below commands

FNDLOAD apps/ apps 0 Y UPLOAD $XDO_TOP/patch/115/import/xdotmpl.lct  <Defn_Name>.ldt

FNDLOAD apps / apps 0 Y UPLOAD $FND_TOP/patch/115/import/afcpprog.lct <Conc_prog_name>.ldt

• Upload physical rtf template

java oracle.apps.xdo.oa.util.XDOLoader UPLOAD \

-DB_USERNAME apps \

-DB_PASSWORD apps \

-JDBC_CONNECTION pra.host.com:1527:<SID> \

-LOB_TYPE TEMPLATE \

-APPS_SHORT_NAME < Custom_Application > \

-LOB_CODE < TemplateDefn _Code> \

-LANGUAGE en \

-TERRITORY US \

-XDO_FILE_TYPE RTF \

-FILE_CONTENT_TYPE ’application/rtf’ \

-FILE_NAME <Template_File_Name>.rtf \

-NLS_LANG ENGLISH_UNITED STATES.WE8ISO8859P1

• Upload physical Data Template if you have one.

java oracle.apps.xdo.oa.util.XDOLoader UPLOAD \

-DB_USERNAME apps \

-DB_PASSWORD apps \

-JDBC_CONNECTION pra.host.com:1527:<SID> \

-LOB_TYPE DATA_TEMPLATE \

-APPS_SHORT_NAME <Custom_Application> \

-LOB_CODE <DataDefn_Code> \

-LANGUAGE en \

-TERRITORY US \

-XDO_FILE_TYPE XML \

-FILE_NAME <DataDefn_File_Name>.xml \