My Oracle Support Banner

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 and later
Information in this document applies to any platform.


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?


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

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

In this Document

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