Wednesday 2 November 2016

How to migrate XML Publisher report with data template from one instance to other using LDT.

In Xml Publisher report when we use data template please follow below given are step to migrate xml publisher report from one instance to another instance using LDT.

Key Object LDT to be downloaded from dev instance.
1. Concurrent Program LDT
2. Any value set or lookup used in lookup for data template query.
3. Data definition and template LDT file.
4. .xml file attached in data definition data template.
5..rtf file attached in template for layout.

LDT Creation scripts:

1. Concurrent Program
Download :
$FND_TOP/bin/FNDLOAD apps/Password O Y DOWNLOAD $FND_TOP/patch/115/import/afcpprog.lct XXCUST_CP.ldt PROGRAM APPLICATION_SHORT_NAME="XXCUST" CONCURRENT_PROGRAM_NAME="XXCUST_SHORT_NAME"

Upload :
FNDLOAD <username>/<password> O Y UPLOAD $FND_TOP/patch/115/import/afcpprog.lct XXCUST_CP.ldt CUSTOM_MODE=FORCE UPLOAD_MODE=REPLACE

2. Data Definition and Template
Download :
FNDLOAD apps/password 0 Y DOWNLOAD $XDO_TOP/patch/115/import/xdotmpl.lct XXCUST_DD.ldt XDO_DS_DEFINITIONS APPLICATION_SHORT_NAME='XXCUST' DATA_SOURCE_CODE='XXCUST_DD_NAME'

Upload:
FNDLOAD apps/XXXX 0 Y UPLOAD ${XDO_TOP}/patch/115/import/xdotmpl.lct XXCUST_DD.ldt

3. Data Template (.xml source file) 
Download :
java oracle.apps.xdo.oa.util.XDOLoader DOWNLOAD -DB_USERNAME apps -DB_PASSWORD userpswd -JDBC_CONNECTION '(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST='HOST NAME')(PORT=1234))(CONNECT_DATA=(SERVICE_NAME=DEV)))' -LOB_TYPE DATA_TEMPLATE -LOB_CODE XXCUST_DD_NAME -APPS_SHORT_NAME XXCUST -LANGUAGE en -lct_FILE $XDO_TOP/patch/115/import/xdotmpl.lct -LOG_FILE $LOG_FILE_NAME

Upload :
java oracle.apps.xdo.oa.util.XDOLoader \
UPLOAD \
-DB_USERNAME apps \
-DB_PASSWORD XXXX \
-JDBC_CONNECTION Server:DBPort:InstanceName \
-LOB_TYPE DATA_TEMPLATE \
-APPS_SHORT_NAME XXCUST \
-LOB_CODE XXCUST_DD_NAME \
-TERRITORY 00 \
-XDO_FILE_TYPE XML-DATA-TEMPLATE \
-FILE_NAME DATA_TEMPLATE_XXCUST.xml \
-CUSTOM_MODE FORCE

4. RTF Template (Layout .rtf file)

Download:
java oracle.apps.xdo.oa.util.XDOLoader DOWNLOAD -DB_USERNAME apps -DB_PASSWORD userpswd -JDBC_CONNECTION '(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST='HOST NAME')(PORT=1234))(CONNECT_DATA=(SERVICE_NAME=DEV)))'  -LOB_TYPE TEMPLATE -LOB_CODE ZBRAR_WFACT_INV_EXTRACT -APPS_SHORT_NAME AR -LANGUAGE en -TERRITORY US -lct_FILE $XDO_TOP/patch/115/import/xdotmpl.lct -LOG_FILE $LOG_FILE_NAME


Upload :
java oracle.apps.xdo.oa.util.XDOLoader \
UPLOAD \
-DB_USERNAME apps \
-DB_PASSWORD XXXX \
-JDBC_CONNECTION Server:DBPort:InstanceName \
-LOB_TYPE TEMPLATE \
-APPS_SHORT_NAME XXCUST \
-LOB_CODE XXCUST_DD_NAME \
-LANGUAGE en \
-TERRITORY 00 \
-XDO_FILE_TYPE RTF \
-FILE_NAME TEMPLATE_SOURCE_XXCUST_TMP_en.rtf \
-CUSTOM_MODE FORCE

1 comment:

  1. I'm very happy to search out this information processing system. I would like to thank you for this fantastic read!!
    Learn XML Publisher Reports for Beginners Actual cost of this course is 9,999/- But now Kuncham Software Solutions Pvt ltd is giving you Free access. Limited period offer Hurry-up Enroll Now at Udemy.


    Hurry-Up Enroll Now and get Free Access to the Entire Course

    ReplyDelete

AP Invoice Notes related Table details in Oracle Fusion

 What is the table that stores the AP Invoice notes? AP notes are stored in ZMM_NOTES table with SOURCE_OBJECT_CODE = 'AP_STANDARD_INVOI...