My Oracle Support Banner

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.

Goal

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.

Solution

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.