Search This Blog

Monday, July 5, 2021

Translate the oracle workflow process name and description in Arabic (or any other language)

 

Before applying the below steps, run the below sql query to check what is the display_name, description in other languages.


ex:

SELECT * FROM WF_ACTIVITIES_TL WHERE ITEM_TYPE='HRSSA'

AND NAME='HR_EIT_VEN_PRC'; --> it is same in english for both US, AR languages


  

1.  download hrssa.wtf file from the workflow loader and open the file in notepad++ or any editor.

change in the file as below

1.1 LANGUAGE = "AR" in the line 9

1.2 update all the process_names display and description in arabic

1.3 save the file under the /orasb/XXCLONE/apps/apps_st/appl/per/12.0.0/patch/115/import/AR

2. in Putty :  export NLS_LANG=ARABIC_AMERICA.UTF8  

3. WFLOAD apps/apps 0 Y UPLOAD /orasb/DEVAP/apps/apps_st/appl/per/12.0.0/patch/115/import/AR/hrssa.wft


Testing:

run the above query to check the display_name, description changed in to lang.


SELECT * FROM V$NLS_PARAMETERS;

alter session set NLS_LANGUAGE ='ARABIC'

ARABIC.AMERICA.UTF8