How to migrate XLIFF files

XLIFF files can be migrated between Oracle instances using scripts. This is shown below.
Download XLIFF translations
To download the XLIFF files the script will be in the structure as below.

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

-DB_USERNAME  \

-DB_PASSWORD  \

-JDBC_CONNECTION  \

-APPS_SHORT_NAME <application_short_name> \

-DS_CODE  \

-TEMPLATE_CODE  \

-FILES_DIR  \

-SUMMARY

_FILE 

Working 
sample

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

-DB_USERNAME apps \

-DB_PASSWORD apps_dev6 \

-JDBC_CONNECTION dev6.na.******.co

m:1531:DEV6 \

-

APPS_SHORT_NAME AMW 

\

-T

EMPLATE_CODE XXEMPDET

The script has downloaded 2 XLIFF files. If you pick up the SQL script from the screen you will get, 

SELECT   l.application_short_name, lob_code, LANGUAGE, territory

    FROM xdo_lobs l,

         (SELECT application_short_name, template_code

            FROM xdo_templates_b

           WHERE mls_language IS NOT NULL

             AND application_short_name = :apps_short_name

             AND template_code = :template_code) b

   WHERE lob_type = 'MLS_TEMPLATE'

     AND l.application_short_name = b.application_short_name

     AND l.lob_code = b.template_code

ORDER BY l.application_short_name, l.lob_code

Executing the script in the database gives us 2 records for 2 translations

If we check for the translations on the template in XML Publisher Administrator responsibility we see that there are 2 active translations.

We see the XLIFF download script has functioned properly.

Upload XLIFF translations
Once  the XLIFF translations are downloaded the files can be uploaded to the target Oracle instance using the script below.

java oracle.apps.xdo.oa.util.XLIFFLoader UPLOAD \

-DB_USERNAME <db_username> \

-DB_PASSWORD  \

-JDBC_CONNECTION  \

-APPS_SHORT_NAME p

lication_short_name> \

-TEMPLATE_CODE  \

-OWNER  \

-CUSTOM_MODE [FORCE|NOFORC

E] \

-FILE_NAME

Working sample

java oracle.apps.xdo.oa.util.XLIFFLoader UPLOAD \

-DB_USERNAME apps \

-DB_PASSWORD apps_dev6 \

-JDBC_CONNECTION dev6.na.*****.com:1

531:DEV6 \

-APP

S_SHORT_NAME AMW \

-TEMPLATE_CODE XXEMPDET \

-FILE_NAME AMW_XXEMPDET_es_00.xlf

The translation will be loaded to the template in the target instance.