Unable To Add Child Product (Or Group) Via Webservice If Parent Territory Has Parent-Product-Group Assigned.

(Doc ID 1585650.1)

Last updated on AUGUST 30, 2016

Applies to:

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

Symptoms

On :  11.1.5.0  version Releadse5 PB14 , Other Issues

ACTUAL BEHAVIOR  
-------------------------
In scope of a Territory Migration :
 If Territory (for example the root Territory) has the root Product-Group assigned, user is not able to add to a child Product-Group to any child-Territory by using Web Service
TerritoryPublicService and Operation CreateNewTerritoryRuleBoundary (containing this child Product-Group) as get error

ERROR
--------
env:Server
 JBO-27023: Failed to validate all rows in a transaction.JBO-27024: Failed to validate a row with key oracle.jbo.Key[300000001780902 ] i
n TerritoryEOJBO-27024: Failed to validate a row with key oracle.jbo.Key[300000001780974 ] in TerritoryRuleEOJBO-27024: Failed to validate a row with key oracle.jbo.Key[300000002066218 ] in TerritoryRuleBoundaryEOJBO-27024: Failed to validate a row with key oracle.jbo.Key[300000002066219 ] in TerritoryRuleBndryValueEOJBO-29000: Unexpected exception caught: java.lang.ClassCastException, msg=oracle.apps.sales.territoryMgmt.territories.territoryService.applicationModule.TerritoryPublicAMImpl: oracle.apps.sales.territoryMgmt.territories.territoryService.applicationModule.TerritoryPublicAMImpl

Note that :
From UI (User Interface) its possible to assign:

Navigation > Territories and Quotas > Territory Proposals
Using Parent Territory : Oracle Europe --> Oracle Product Catalog
GSA --> Oracle Hierarchy > Assign a child product of parent Territory Product group


EXPECTED BEHAVIOR
-----------------------
 If Territory (for example the root Territory) has the root Product-Group assigned, it should be possible add/assign a child Product-Group to any child-Territory by using Web Service :
mergeTerritoryInProposal.CreateNewTerritoryRuleBoundary (containing this child Product-Group) as get error


STEPS
-----------------------
The issue can be reproduced at will with the following steps:

In scope of Territories migration global procedure :


BUSINESS IMPACT
-----------------------
The issue has the following business impact:
If a Territory (for example the root Territory) has the root Product-Group assigned, administrator users are not able to add to a child Product-Group to any child-Territory.
by using web-services as it is possible manually in scope of UI

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