FAGLTRN Transfer Journal Entries to GL - Assets Fails for Non-English Languages (Doc ID 2050159.1)

Last updated on NOVEMBER 08, 2022

Applies to:

Symptoms

When attempting to run FAGLTRN: Transfer Journal Entries to GL - Assets in Portuguese, the following error occurs.

ERROR
-----------------------
One or more post-processing actions failed. Consult the OPP service log for details.
  
CONC-POST-PROCESSING RESULTS
  
-- PUBLISH:
oracle.apps.fnd.cp.opp.PostProcessorException:
oracle.apps.fnd.cp.opp.PostProcessorException: oracle.apps.xdo.XDOException:
No corresponding LOB data found :
SELECT L.FILE_DATA FILE_DATA,DBMS_LOB.GETLENGTH(L.FILE_DATA) FILE_LENGTH,
L.LANGUAGE LANGUAGE, L.TERRITORY TERRITORY, B.DEFAULT_LANGUAGE
DEFAULT_LANGUAGE, B.DEFAULT_TERRITORY DEFAULT_TERRITORY,B.TEMPLATE_TYPE_CODE
TEMPLATE_TYPE_CODE, B.USE_ALIAS_TABLE USE_ALIAS_TABLE, B.START_DATE
START_DATE, B.END_DATE END_DATE, B.TEMPLATE_STATUS TEMPLATE_STATUS,
B.USE_ALIAS_TABLE USE_ALIAS_TABLE, B.DS_APP_SHORT_NAME DS_APP_SHORT_NAME,
B.DATA_SOURCE_CODE DATA_SOURCE_CODE, L.LOB_TYPE LOB_TYPE FROM XDO_LOBS L,
XDO_TEMPLATES_B B WHERE L.APPLICATION_SHORT_NAME= :1 AND L.LOB_CODE = :2 AND
L.APPLICATION_SHORT_NAME = B.APPLICATION_SHORT_NAME AND L.LOB_CODE =
B.TEMPLATE_CODE AND (L.LOB_TYPE = 'TEMPLATE' OR L.LOB_TYPE = 'MLS_TEMPLATE')
AND ( (L.LANGUAGE = :3 AND L.TERRITORY = :4) OR (L.LANGUAGE=
B.DEFAULT_LANGUAGE AND L.TERRITORY= B.DEFAULT_TERRITORY ))

The report finishes without errors when run in English.

Changes

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.