25. OAF Multi Language text (Ex: Arabic, French)

In our Company we have Both English and Arabic Instances for Oracle Apps R12.1.3
So If we create any Custom OAF Page we need to add the Arabic Labels. Let see how to add them.
Example:
Page:ResultBaseSearchPG
Step1: Create folder under D: Drive as Temp
Step2: run the below command in cmd.
D:\JDev_Home\jdevbin\oaext\bin\xliffextract /xxresultbasesearch/oracle/apps/po/resultbasesearchprj/webui/ResultBaseSearchPG
-root D:\JDev_Home\jdevhome\jdev\myprojects
-source db -username apps -password apps
-dbconnection "(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=tcp)(HOST=10.10.10.10)(PORT=1521)))(CONNECT_DATA=(SERVICE_NAME=VIS)))"
-languages ar-AE
-mmd_dir D:\JDev_Home\jdevbin\oaext\config\mmd
-xliff_dir D:\Temp\XLIF\XXTFRMSLAUC19

below is same as above but in single line to directly paste in cmd prompt:
D:\JDev_Home\jdevbin\oaext\bin\xliffextract /xxffrd/oracle/apps/xxcust/ffrd/webui/ResultBaseSearchPG -root D:\JDev_Home\jdevhome\jdev\myprojects  -source db -username apps -password apps  -dbconnection "(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=tcp)(HOST=10.10.10.10)(PORT=1521)))(CONNECT_DATA=(SERVICE_NAME=VIS)))"  -languages ar-AE  -mmd_dir D:\JDev_Home\jdevbin\oaext\config\mmd  -xliff_dir D:\Temp\XLIF\ResultBaseSearchPGAR

Step3: The above command will create xlf file under D:\Temp\XLIF\ResultBaseSearchPGAR
Open the xlf file> change the text for all the <target>
Let say:
Before:
<source>FileNumber</source>
           <target>FileNumber</target>
           <prop-group name="ora_untranslatable">
              <prop prop-type="tagName">messageStyledText</prop>
              <prop prop-type="attributeName">prompt</prop>
After Mofication:

<source>FileNumber</source>
           <target>رقم الملف</target>
           <prop-group name="ora_untranslatable">
              <prop prop-type="tagName">messageStyledText</prop>
              <prop prop-type="attributeName">prompt</prop>

-- It was before FileNumber in <target> we changed to our Arabic Language and save it.

Step4:
Importing the Translation in to Apps:
D:\JDev_Home\jdevbin\oaext\bin\xliffimport -username apps -password apps -dbconnection "(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=tcp)(HOST=10.10.10.10)(PORT=1521)))(CONNECT_DATA=(SERVICE_NAME=VIS)))" D:\Temp\XLIF\ResultBaseSearchPGAR\ar-AE\ResultBaseSearchPG.xlf

Step5: For export and import of translations no information will be shown in the command prompt unless there is error.

Step6: Just login to apps change the instance to arabic and check it.