How to make a multi Language Message in a (Form-Based Personalization)
1- First you will make your personalization (contain a message action) on the form you want to print the message.
2- Copy and paste the follwing code in the message body of the personalization action:
=(SELECT DECODE ((SELECT USERENV (‘lang’)
FROM DUAL),
‘US’, ‘English Message’,
‘AR’, ‘Arabic Message’
) Message
FROM DUAL)
3- Write your (English message body) instead of ‘English Message’ in the code, and your (Arabic message body) instead of ‘Arabic Message’ in the code.
EX: (English message body) => ‘Hello World’
(Arabic message body) => ‘أهلا وسهلا’
4- Save your work and test.
Now, when you login to the application with the (English) language, the (English message) will appear when you fire the personalization, and when you login to the application with the (Arabic) language, the (Arabic message) will appear when you fire the same personalization.