Oracle Apex multi language can not access the view with fnd_profile.value('ORG_ID')
I have create an apex(version 19.2) application with multiple language, the primary language is english(en), and the translation language is Chinese(zh-tw).
the region source from a SQL to select a DB view, the view has condition ORG_ID = FND_PROFILE.VALUE('ORG_ID').
the Oracle DB language is US only, when I switch apex language to english, I can see the region show the data from the view, but when I switch apex language to Chinese, the region shows nothing. Why?
How can I do to fix this issue?
Thanks in advance.