Restrict Visibility On DCL Field Not Working

(Doc ID 2230162.1)

Last updated on FEBRUARY 03, 2017

Applies to:

Oracle Fusion Sales Cloud Service - Version 11.1.11.1.0 and later
Oracle Fusion Sales - Version 11.1.11.1.0 and later
Information in this document applies to any platform.

Symptoms

On : 11.1.11.1.0 version, Accounts, Contacts, Households

ACTUAL BEHAVIOR
---------------
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)))

Above:
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.

EXPECTED BEHAVIOR
-----------------------
The options available in the DCL should be limited; only showing the values that are specified for that customer.

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot restrict user's usage appropriately.

Cause

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