Territory Owner Is Not Displayed Correctly In A Formula Field (Doc ID 2231969.1)

Last updated on FEBRUARY 16, 2017

Applies to:

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

Symptoms

On : 11.1.11.1.0 version, Territory Management, Quotas

ACTUAL BEHAVIOR
---------------
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")
vci.setOperator('=')
vci.setValue(SalesChnl_c)
vc.insertRow(vcr)
vo.appendViewCriteria(vc)
vo.executeQuery()
def condition
while (vo.hasNext())
{
def curRow = vo.next()
condition = curRow.getAttribute("Owner");
}
return condition
}
else
{
return ""
}

 

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.

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