My Oracle Support Banner

Data Fetching Issue In CS_INCIDENTS_B_SEC and CS_SR_UWQ_GROUP_V View When Standard Security Is Enabled (Doc ID 2272638.1)

Last updated on JUNE 01, 2017

Applies to:

Oracle Teleservice - Version 12.2.5 and later
Information in this document applies to any platform.

Goal

When setup for Service System Parameters to Standard Security with 'Service Request Type Security' enabled and 'Enforce Service Request Type Security in iSupport' is enabled,
then CS_INCIDENTS_B_SEC and CS_SR_UWQ_GROUP_V view is not fetching any data but when above setup is disable then data is returning.

How to make the below SQL to return data when standard security is set?

 

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.