Territory Owner Is Not Displayed Correctly In A Formula Field
Last updated on FEBRUARY 16, 2017
Applies to:Oracle Fusion Sales Cloud Service - Version 220.127.116.11.0 and later
Information in this document applies to any platform.
On : 18.104.22.168.0 version, Territory Management, Quotas
Territory Owner change is not reflected in a formula field
There is a custom text formula field in a custom object which fetches the Territory Owner from territory proposals.
The script in formula field is:
if(nvl(SalesChnl_c,"") != "")
def vo = newView('TerritoryPVO')
println('new view created')
def vc = newViewCriteria(vo)
def vcr = vc.createRow()
def vci = vcr.ensureCriteriaItem("Name")
def curRow = vo.next()
condition = curRow.getAttribute("Owner");
The script works fine for the majority of the records and territory owners but not for the last change in proposals where the territory owner is replaced by someone else.
The customer tried to change the Owner and put back the correct owner without any success even after territory dimension synchronization.
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