Wednesday, July 20, 2022

how to change All HRMS WorkFlow Notifications To Arabic

case

we needs to Download The HR Workflow but instead of English Descriptions and all the Subjects we needs to appears it by Arabic language so instead of Update every Notification Subject for Example we will Download it all using FNDLoad Command as Arabic translated then Upload it when needed aftet



 Solution

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

/************************/


Step1:  update nls_lang (regedit then search for NLS of ORACLE) to be AMERICAN_AMERICA.AR8MSWIN1256


Step2 : region language of the local Machine

 

Nav: Control Pannelà RegionàAdministrativeà


Step3 : make sure or alter table of fnd_languages  as per the is Query

select * from wf_languages where INSTALLED_FLAG = 'Y'





Step :4 using putty export script as below

export NLS_LANG='ARABIC_AMERICA.AR8MSWIN1256'

WFLOAD apps/apps 0 Y DOWNLOAD HR.wft HRSSA




Thanks 

Taher Amin 

Mail to :- e.taher.amin@Gmail.com




























 




No comments:

Post a Comment

SQL Query to Convert number into Words for Money

SELECT INITCAP ( DECODE ( FLOOR (TO_NUMBER ( :amount)), 0, '', TO_CHAR (TO_DATE...