EBS Customizations (MOSC)

MOSC Banner

Can Alert Inputs Be Any More Flexible?

edited Feb 8, 2019 5:36PM in EBS Customizations (MOSC) 6 commentsAnswered ✓

I have a brain teaser for the Community: Can anyone tell me if there is a way to pass multiple values into an Alert Input? E.g, I want my Select Statement to look something like " SELECT 'true' INTO &OUTPUT1 FROM dual where 1 in (:test_vals) " and to return the single record containing "true" when test_vals contains "1". The real-world goal includes including or excluding sets of operating units without needing to create dedicated Alert Actions when the email to be generated is exactly the same and can be dynamically directed to appropriate individuals. Consider how two B2B OUs

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