How To Define The Sql Statement Of A Dynamic Group For Employees?
(Doc ID 275125.1)
Last updated on JULY 21, 2020
Applies to:Oracle iSupport - Version 11.5.9 to 12.2 [Release 11.5 to 12.2]
Information in this document applies to any platform.
How to define the sql statement of a dynamic group for employees?
You are implementing in a group of companies and would like to create a dynamic group so that only employees of certain companies can view the alerts.
You have gotten the alerts to work for a simple case with a dynamic group using the following sql:
select party_id from hz_parties where party_name like '¾cerril%',
So the problem is not with how to use the functionality but rather in formulating the correct sql statement for your purpose.
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!