Friday 7 December 2012

XML report template migration from one instance to another


RTF template migration from A instance to B instance.
Here XX is the custom application

---template definition download command
SELECT    'FNDLOAD apps/app5 0 Y DOWNLOAD $XDO_TOP/patch/115/import/xdotmpl.lct '
       || template_code
     || '.ldt XDO_DS_DEFINITIONS'
  FROM xdo_templates_b
 WHERE application_short_name = 'XX'

---template definition upload command
SELECT    'FNDLOAD apps/apps 0 Y UPLOAD $XDO_TOP/patch/115/import/xdotmpl.lct '
       || template_code
       || '.ldt'
  FROM xdo_templates_b
 WHERE application_short_name = 'XX'

--template file download command
SELECT    'java oracle.apps.xdo.oa.util.XDOLoader DOWNLOAD -DB_USERNAME <apps> -DB_PASSWORD <apps> -JDBC_CONNECTION <A IP:PORT:SID> -LOB_TYPE '
       || lob_type
       || ' -APPS_SHORT_NAME '
       || application_short_name
       || ' -LOB_CODE '
       || lob_code
       || ' -LANGUAGE '
       || LANGUAGE
       || ' -TERRITORY '
       || territory
  FROM xdo_lobs
 WHERE application_short_name = 'XX' ;

--template file upload command
SELECT    'java oracle.apps.xdo.oa.util.XDOLoader UPLOAD -DB_USERNAME <apps> -DB_PASSWORD <apps> -JDBC_CONNECTION <B IP:PORT:SID> -LOB_TYPE '
       || lob_type
       || ' -APPS_SHORT_NAME '
       || application_short_name
       || ' -LOB_CODE '
       || lob_code
       || ' -LANGUAGE '
       || LANGUAGE
       || ' -TERRITORY '
       || territory
       || ' -XDO_FILE_TYPE '
       || xdo_file_type
       || ' -FILE_CONTENT_TYPE '''
       || file_content_type
       || ''' -FILE_NAME '
       || lob_code
  FROM xdo_lobs
 WHERE application_short_name = 'XX'

2 comments:

  1. Thanks for the good article. Hey I just want to ask you that it will be very helpful for freshers who wants to have knowledge on table linking in r12 (ap,ar,gl,inv,om,po)

    ReplyDelete