0 Replies Latest reply on Jul 26, 2016 5:21 PM by 2613511

    Migrating XML Publisher reports across instances with FNDLOAD and XDOLoader

    2613511

      Hi Experts,

       

      I am looking for a way to migrate XML Publisher report which is developed in development instance to test instance (R12.2.1). On looking out, lot of internet searches gave me the below two utilities but I do not understand which is mandatory (keywords/symbols/spaces) and which are just an example in the below. Can someone write a correct command for me with the given details. It would be a great help. Thanks

       

      These are the example commands:

       

      1. For downloading and uploading data definition and data template (Please clarify if this single command will download both or I need to use it any differently) :

       

      FNDLOAD apps/apps_pwd@db 0 Y DOWNLOAD $XDO_TOP/patch/115/import/xdotmpl.lct

      targetldtfile.ldt XDO_DS_DEFINITIONS APPLICATION_SHORT_NAME=XXX DATA_SOURCE_CODE=EMP_DD


      FNDLOAD apps/apps_pwd@db 0 Y UPLOAD $XDO_TOP/patch/115/import/xdotmpl.lct

      targetldtfile.ldt


      2. For downloading and uploading physical files :


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

      -DB_USERNAME apps \

      -DB_PASSWORD welcome \

      -JDBC_CONNECTION r12.com:1533:R124 \

      -APPS_SHORT_NAME AMW \

      -LCT_FILE ${XDO_TOP}/patch/115/import/xdotmpl.lct \

      -DS_CODE EMP_DD


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

      UPLOAD \

      -DB_USERNAME apps \

      -DB_PASSWORD welcome \

      -JDBC_CONNECTION r12.com:1533:R124 \

      -LOB_TYPE TEMPLATE \

      -APPS_SHORT_NAME AMW \

      -LOB_CODE EMP_DD \

      -LANGUAGE en \

      -TERRITORY US \

      -NLS_LANG American_America.WE8ISO8859P1 \

      -XDO_FILE_TYPE RTF \

      -FILE_CONTENT_TYPE ’text/html’ \

      -FILE_NAME /tmp/psomanat/TEMPLATE_SOURCE_AMW_Emp_Template_en_US.rtf

      ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

      Now my details are: Please use these details and help me write correct and exact commands

       

      Data definition name: SAMPLE_DD (and same short name)

      Data template name: SAMPLE_DT

      Application Short name: XXGE

      Data template file name (.xml attached to Data Definition) : my_file.xml

      RTF Template name (RTF attached to data template) : my_layout.rtf

      Bursting File name: Split_data.xml

      Host: asserpdevdb1.sorus.com

      Port Number: 1531

      SID: ASSERPDEV

      Database username/password: APPS/Passw0rd1

       

      Note: I have no idea about download or upload location, please throw some light on that. Is the download location defaulted? And what would be the upload location for these downloaded files?

       

      Thanks!!