Technology Stack - EBS (MOSC)

MOSC Banner

Forms Personalization fails when field being validated contains non-ascii character

edited Aug 20, 2021 10:59AM in Technology Stack - EBS (MOSC) 2 commentsAnswered

We have a forms personalization on a standard Oracle form that checks for a combination of values in 2 fields and should throw an error if this scenario exists:

${item.rgw_folder.m_customer_number.value} IS NOT NULL AND ${item.rgw_folder.m_location.value} IS NULL

The location field pulls from the Oracle Customer Location field, which is VARCHAR2 and sometimes we have found non-ascii values in this field.  An example that we just found is that the location field contained an acute accent (´) in place of an apostrophe.

When this FP triggers and evaluates this value in the m_location, it throws an error (The condition <...> could not be evaluated because of error).

Tagged:

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