My Oracle Support Banner

Field Updatable Timing Issue (Doc ID 2106901.1)

Last updated on SEPTEMBER 11, 2020

Applies to:

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


On Opportunity:

***Short summary:***

The field updateable condition is running before saving the value in a system, therefore erasing the last entered value.

***Full problem description:***

I am trying to solve a business rule for a field that is at the same time:
1) An always-required field
2) A fixed-picklist with conditional display mapping
3) It should be editable only on the "creation" layout, but not on "edit" layout.
4) The "edit" layout choice is dependent on this field

So to sum it up: the field OpportunityType_c is dependent on the field LogisticsRail_c and in "Logistics" case can have two values: "Transportations" or "CL/SCM", with 'Transportations' being a default value (filled by After Create trigger). Picking either one of them and saving results in opening an according editing layout. However we don't want it to be possible to change the Opportunity Type after it was first saved (save and continue).

I have a function in the "Updateable constraints" which looks like this:

case 'OpportunityType_c':
if(nvl(Name, 'NA') != 'NA'){
return false
return true

As the "Name" field is initially empty and should be always field upon save, I simply check if there is a value in there: if its empty the field should be updateable and vice versa.
However if I select "CL/SCM" and press save - the field value is returned to its default value, so I have "Transportations" layout with uneditable field OpportunityType_c. I believe it is happening because the updateable condition is triggering before saving the value in the field.
If i delete the default value I get an "empty field" error each time upon save.

What to recommend in this case?


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.