NLS PT R12 Patch application error oracle.apps.xdo.XDOException: Template ARXAGFMX not found

NLS PT R12 Patch application error oracle.apps.xdo.XDOException: Template ARXAGFMX not found

Error:

Parameters passed to XLIFFLoader...
[FILE_NAME] [ apps/apps_st/appl/ar/12.0.0/patch/115/publisher/templates/PT/ARXAGF.xlf]
[APPS_SHORT_NAME] [AR]
[UPLOAD] [UPLOAD]
[DB_USERNAME] [APPS]
[JDBC_CONNECTION] [(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=hostname.domain.com)(PORT=1551))(CONNECT_DATA=(SID=VISR12)))]
[DB_PASSWORD] [******]
[TEMPLATE_CODE] [ARXAGFMX]

Target file: ARXAGF.xlf
Start uploading...
oracle.apps.xdo.XDOException: Template ARXAGFMX not found
        at oracle.apps.xdo.oa.util.TemplateTranslator.getBaseTemplateInfo(TemplateTranslator.java:338)
        at oracle.apps.xdo.oa.util.TemplateTranslator.createMLSTemplates(TemplateTranslator.java:210)
        at oracle.apps.xdo.oa.util.XLIFFLoader.processUpload(XLIFFLoader.java:709)
        at oracle.apps.xdo.oa.util.XLIFFLoader.process(XLIFFLoader.java:565)
        at oracle.apps.xdo.oa.util.XLIFFLoader.main(XLIFFLoader.java:1073)



Solution:

1. Run this.
java oracle.apps.xdo.oa.util.XDOLoader UPLOAD \
-DB_USERNAME apps \
-DB_PASSWORD \
-JDBC_CONNECTION \
-LOB_TYPE TEMPLATE_SOURCE \
-APPS_SHORT_NAME AR \
-LOB_CODE ARXAGFMX \
-LANGUAGE en \
-TERRITORY US \
-XDO_FILE_TYPE RTF \
-FILE_NAME $AR_TOP/patch/115/publisher/templates/US/ARXAGF.rtf \
-CUSTOM_MODE FORCE


2. Once 1 is successful run this.

UPDATE xdo_templates_b
SET mls_language = 'en', mls_teritorry = 'US'
WHERE application_short_name = 'AR'
and template_code = 'ARXAGFMX';

3. Then restart the failed worker which was working ARXAGF.xlf.

For more info rollow the below document

Patch 12702898:R12.AR.A Fails With oracle.apps.xdo.XDOException: Template ARXAGFMX not found (Doc ID 1495265.1)