EBS Customizations (MOSC)

MOSC Banner

Constraining values

edited Mar 29, 2011 4:07AM in EBS Customizations (MOSC) 2 commentsAnswered
hi folks,
i have a rather tricky requirement. i have a need to constrain user-entered values within a concurrent program's parameter such that the value *should not* be a duplicate.

we are in the process of creating a custom concurrent program. when a user selects this program to be submitted, a few parameters will need to be entered. amongst them is a parameter - Shipment Number. now that parameter's flexfield should prevent the user from submitting a value that have already been used as a Shipment Number in an earlier transaction (i can look it up using a value set or some such). essentially, this could be a free-text or value-set field that just needs to ensure that the value is not a duplicate based a check of preexisting records

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