My Oracle Support Banner

Territory Search Province LOV Does Not Check For End-Date (Doc ID 2712236.1)

Last updated on SEPTEMBER 20, 2020

Applies to:

Oracle Territory Management - Version 12.1.3 and later
Information in this document applies to any platform.

Symptoms


ACTUAL BEHAVIOR

When searching the Territory with Usage Sales, the option for Province LOV shows a value twice.
In Geography Hierarchies, it is defined only once.
In the table, hz_geographies, this is defined twice, but one of them is end-dated.

 

EXPECTED BEHAVIOR

Expected behavior is that the LOV should show only the the active value.

STEPS

The issue can be reproduced at will with the following steps:
1. Territory Management > Territory Administration > Territories > Click on the 'Search' button >
2. In the Province Field enter a value >
3. The LOV shows this value twice (even though one entry is end-dated)

BUSINESS IMPACT

The issue has the following business impact:
Due to this issue, users can select the end-dated value which has the incorrect 'code' for the province.

Changes

 

Cause

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
Symptoms
Changes
Cause
Solution
References


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