E1: 01: 17: Auto Suggest Business View V0101AS Returns Duplicate Records From F0116 (Doc ID 1935474.1)

Last updated on FEBRUARY 04, 2016

Applies to:

JD Edwards EnterpriseOne Capital Asset Management - Version 9.1 and later
JD Edwards EnterpriseOne Address Book - Version 9.1 and later
Information in this document applies to any platform.

Symptoms

On : 9.1 version, Equipment and Plant Maintenance P1702

Auto-suggest on ALKY, AN8, PA8, ANOB fields displays duplicate records.

Standard auto-suggest Business View for all Address Book fields (ALKY, AN8, PA8, ANOB) is V0101AS.
V0101AS is built on join between F0101 and F0116. F0116 contains multiple records per one F0101 record.
In fact every time somebody hits Save button in P01012 - it creates a new record in F0116 with today's date.

That means that auto-suggest displays duplicate records. This is confusing for end-users. It also makes auto-suggest less useful as instead of 10 records auto-suggest displays only 5 or less.

Solution:
Remove F0116 from V0101AS.
Pros: Auto-suggest will not display duplicate AB#-s
Con: Auto-suggest will not be able to display/search through Mailing Address fields.

EXPECTED BEHAVIOR
-----------------------
Expect business view to filter address book records by effective dates, returning only one record, per address number.

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
From G1311/P1701, select an equipment record.
From P1702, access the Service Tab.
From the Supervisor field, use the visual assist.
Query by alpha name for an address book number that has multiple F0116 date records.
Note that auto-suggest displays duplicate records. This is confusing to users.

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot efficiently use the auto suggest for address book to see up to 10 unique address book numbers due to duplicates limiting the viewable records.

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