EBS Customizations (MOSC)

MOSC Banner

Cross Validation acros Flexfields

edited Jul 26, 2012 2:39AM in EBS Customizations (MOSC) 2 commentsAnswered
Hello,

We have two flexfields setup on Opportunities in Oracle Sales (12.1.3.1) as below -

attribute1, valueset1 (Start Date)
attribute2, valueset2 (End Date)

The attribute1 is designated as Start Date and attribute2 is designated as End Date.

How can I a validation on valueset2 so the date > valueset1, i.e. user can only enter an End Date which is greater than Start Date and not vice versa.

I tried creating valueset2 with Value Validation as “Special” and using a custom SQL when defining the custom validation, but it seems that Special value validation does not work on framework pages… it works only on Forms.

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