Tuesday, 5 May 2015

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 -DB_PASSWORD -JDBC_CONNECTION -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 -DB_PASSWORD -JDBC_CONNECTION -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';

No comments:

Post a Comment

Query to Find Receipt Class and its GL Combinition Query

SELECT ARC.NAME ReceiptClass,        ARC.CREATION_METHOD_CODE Creation_Mehthod,        DECODE (ARC.REMIT_METHOD_CODE,             ...