Inconsistency Between Control Central Geo Search After Upgrade From 2.1 To 2.6 (Doc ID 2591855.1)

Last updated on SEPTEMBER 22, 2022

Applies to:

Symptoms

On : 2.6.0.1.0 version, ENV - Environment

The Control Central Geo Search does not return any results for a scenario when Geo Value is only stored on Service Point and not on Premise, where a non-closed SA exists for the Service Point which is linked to the Premise via the Char Premise ID but has never been linked to the Service Point via the SA/SP, and one other Service Point for the premise has been linked to a closed SA via SA/SP

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Prepare or search for a data where it satisfies the following:
A Service Point where the premise has been linked to a closed Service Agreement via the SA/SP and a Geo Value is only stored on the Service Point and not on Premise
2. A non-closed Service Agreement exists for the Service Point, that is linked to the Premise via the Char Premise ID, but has never been linked to the Service Point via the SA/SP
3. Navigate to Control Central → Main → Control Central Search
Search by Geo Type/Value
Populate the fields according to the Geo Type/Value on the Service Point
Click Search
Notice that it returns no result.

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot see expected result.

Cause

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