My Oracle Support Banner

Multi-Row UDAs Repeat (Duplicate) On Change Order Page When Modifying Many Records (Doc ID 798179.1)

Last updated on MARCH 08, 2019

Applies to:

Oracle Product Hub - Version 12.0.4 and later
Information in this document applies to any platform.

Symptoms

While updating the Multi-row User defined attributes (UDAs) in Engineering Change Orders (ECO), the system is modifying other records that are not modified by the users. In some cases it overwrites the changes done by the users and copies the values from a different record.
An error might show on saving because the information is duplicated.

This happens when a UDA group has more than 70 records.

For more than 70 records, the values from the last displayed record on the first page (typically 5 record) are replacing other records. This makes some attributes appear as duplicates. The similar behavior is also observed when "Hide All Details" link is used for more than 70 records UDA groups. In this case the users are not modifying any information at all, but just using the "Hide All Details" updates the records.

Example Error

There is already a row of "Country Information" with "Country Name" as "Japan". Please enter a distinct value for "Country Name".

-or-

The row of "&AG_NAME" you tried to create already exists or is currently being processed by another program.


What is working
1) Updating item attributes without a change order works fine.
2) The issue does NOT happen on change orders if number of records is 70 or less.
3) The data is actually NOT repeated or corrupted in the table (EGO_MTL_SY_ITEMS_EXT_B). This is just on the screen.


Steps: Setup
1. Create two multi-row UDA groups and associate to an Item catalog category (ICC)
2. In ICC add both UDA groups to same UDA page.
3. Create an item in this ICC and update the UDA groups to have at least 70 records in each UDA group.

Steps: See Issue
1. Create a Change order for this item, try to update these UDA groups
2. Click on 'Hide All Details" link - The new view shows some records are modified in both UDA groups
3. Cancel/ Undo changes
4. Modify one of the UDA groups record (1 to 3) in ECO -- Apply
5. The system shows three changes. 2 in same UDA group and one in another UDA group. Last two are unintentional and not done by user.

NOTE: In the images below and/or the attached document, user details / company name / address / email / telephone number represent a fictitious sample (based upon made up data used in the Oracle Demo Vision instance). Any similarity to actual persons, living or dead, is purely coincidental and not intended in any manner.


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.