Oracle Application Express (MOSC)

MOSC Banner

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.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center