Field Level Constraint Post R12 Upgrade Not Working

(Doc ID 2312343.1)

Last updated on SEPTEMBER 28, 2017

Applies to:

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

Goal


We have a script (below) in place a some fields in Opportunities where only specific Roles are allowed to update if true. This script worked before the R12 upgrade. Now, the 'US TNR Admin' is not given access to update the field. This is set at the field level under Constraints > Updatable. The Role 'US TNR Admin' has the Role Code of 'US TNR Admin' without any underscores. I checked Role permissions and it has Create/Read/Update/Delete rights on Opportunities object. This field is on the Opportunity header under a field group.

def secContx = adf.context.getSecurityContext()
if(secContx.isUserInRole('US TNR Admin') || secContx.isUserInRole('ZBS_SALES_ADMINISTRATOR_JOB') )
{
return true
}
else {return false}

** How to make above script works as before REL12 Upgrade?
 

Solution

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