Restrict Visibility On DCL Field Not Working
Last updated on FEBRUARY 03, 2017
Applies to:Oracle Fusion Sales Cloud Service - Version 220.127.116.11.0 and later
Oracle Fusion Sales - Version 18.104.22.168.0 and later
Information in this document applies to any platform.
On : 22.214.171.124.0 version, Accounts, Contacts, Households
Customer has a custom object.
On this custom object, customer has a DCL field.
DCL field is supposed to show a list of Resource Names.
This list of resource names is suppose to be limited by user based on the following predicate:
&TABLE_ALIAS.EXTN_ATTRIBUTE_NUMBER001 in (SELECT RESOURCE_PROFILE_ID from JTF_RS_RESOURCE_PROFILES WHERE EXTN_ATTRIBUTE_CHAR005 = (select EXTN_ATTRIBUTE_CHAR005 from JTF_RS_RESOURCE_PROFILES where PARTY_ID=(SELECT HZ_SESSION_UTIL.GET_USER_PARTYID FROM DUAL)))
EXTN_ATTRIBUT_NUMBER001 is the Resource Id
EXTN_ATTRIBUTE_CHAR005 is the field from where the customer has to limit.
However, the DCL shows all values instead of just the values limited to what the user should see.
The options available in the DCL should be limited; only showing the values that are specified for that customer.
The issue has the following business impact:
Due to this issue, users cannot restrict user's usage appropriately.
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 hundreds of Community platforms