How to launch OAPP_PGM with a specific Language in OEBS 12

Document ID : KB000100492
Last Modified Date : 07/06/2018
Show Technical Document Details
Introduction:
Since OEBS 12, OAPP_PGM uprocs are always launched in American Language, no matter which Language/Territory has been set in the corresponding parameter:

OAPP_PGM uproc definition
Environment:

Oracle E-Business Suite 12 and Superior with Dollar Universe Manager for Oracle Application.

Instructions:
In order to submit with another Territory/Language, the ux_orapps.ksh has to be modified on the Manager for Oracle Application as it calls the binary CONCSUB.

Two new variables have been introduced on this version for the Language / Territory parameters which are TERRITORY and LANGUAGE.

In order to force all jobs to be submitted in a given language like French / France, please perform the following modification:

1. Backup the file bin/bin_oapp/ux_orapps.ksh
2. Replace the line 
echo ${PASSWD} | ${FND_TOP}/bin/CONCSUB ${DBUSER} "${RESPAPP}" "${RESP}" ${EXECUSERNAME} WAIT=N CONCURRENT ${PGMAPP} "${PGMNAME}" "${ARGS}" ${CONCSUB_PRINT_ARGS}>${Spool_file} 

by:
echo ${PASSWD} | ${FND_TOP}/bin/CONCSUB ${DBUSER} "${RESPAPP}" "${RESP}" ${EXECUSERNAME} WAIT=N CONCURRENT ${PGMAPP} "${PGMNAME}" "${ARGS}" ${CONCSUB_PRINT_ARGS} LANGUAGE="FRENCH" TERRITORY="FRANCE" >${Spool_file} 

3. Relaunch the OAPP_PGM job, this time it will be executed in French.