PeopleTools and Lifecycle Management - PSFT (MOSC)

MOSC Banner

FLUID: SQL error displayed when I click the lookup icon for a date field.

edited Aug 7, 2019 1:31AM in PeopleTools and Lifecycle Management - PSFT (MOSC) 5 commentsAnswered

I have a date field in a Fluid page whose prompt is controlled via a dynamic view. The view sql is populated at runtime. Now, when I enter an invalid date (a value that is not there in the prompt), I get the usual invalid value error. After this I click on the lookup icon to open the search modal. When the search modal comes up, I get a SQL error.

E.g. enter 02/01/2018 in the date field. Note that this is not a valid value according to the prompt. So I get the standard Invalid value message. I click OK and then click on the lookup icon. Now the lookup modal comes up and a

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