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'
A very helpful document
ReplyDeleteThanks 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