My Oracle Support Banner

AML Redline Through Import Is Not Reflected Partially (Doc ID 2646036.1)

Last updated on MARCH 05, 2020

Applies to:

Oracle Agile PLM Framework - Version 9.3.5.0 and later
Information in this document applies to any platform.

Symptoms

ACTUAL BEHAVIOR
When trying to import a source file having 2 scenario in single source file, like below :

  1) Redline existing Item's MPN Preferred Status attribute
  2) Add new MPN record to an item having same Mfr.Part Number but with new manufacturer name to insert as new redline row

importing aml with above conditions will result in only 2) being reflected to the change, while 1) are not being redlined.

FACT
1. When the source file includes only 2 rows, issue does not occur.
2. When the source file are over 149 records in total to import, issue will occur

STEPS
The issue can be reproduced at will with the following steps:
1. Create new Manufacturer : yoManufacturer2

2. Import aml75-import-to-Part.xlsx to mpn to create new 75 parts with mpn set
   by Item > Approved Manufacturer List (No change specified)

Item         Mfr.Name             Mfr.Part Number    Type
-----------------------------------------------------------------------
P00001    YoManufacturer    yo0217mpn1        Manufacturer Part
P00002    YoManufacturer    yo0217mpn2        Manufacturer Part
P00003    YoManufacturer    yo0217mpn3        Manufacturer Part
P00004    YoManufacturer    yo0217mpn4        Manufacturer Part
P00005    YoManufacturer    yo0217mpn5        Manufacturer Part
P00006    YoManufacturer    yo0217mpn6        Manufacturer Part
P00007    YoManufacturer    yo0217mpn7        Manufacturer Part
P00008    YoManufacturer    yo0217mpn8        Manufacturer Part
P00009    YoManufacturer    yo0217mpn9        Manufacturer Part
P00010    YoManufacturer    yo0217mpn10      Manufacturer Part

...

P00070    YoManufacturer    yo0217mpn70      Manufacturer Part
P00071    YoManufacturer    yo0217mpn71      Manufacturer Part
P00072    YoManufacturer    yo0217mpn72      Manufacturer Part
P00073    YoManufacturer    yo0217mpn73      Manufacturer Part
P00074    YoManufacturer    yo0217mpn74      Manufacturer Part
P00075    YoManufacturer    yo0217mpn75      Manufacturer Part

3. Import amlredline-update-insert150-import1.xlsx to redline 75 part to modify Preferred Status to Alternate and add
    new redline record for same mpn number but different mfr.name (total of 150 record)
   
Item         Mfr.Name             Mfr.Part Number    Type                        Preferred Status
------------------------------------------------------------------------------------------
P00001    YoManufacturer    yo0217mpn1        Manufacturer Part    Alternate
P00002    YoManufacturer    yo0217mpn2        Manufacturer Part    Alternate
P00003    YoManufacturer    yo0217mpn3        Manufacturer Part    Alternate
P00004    YoManufacturer    yo0217mpn4        Manufacturer Part    Alternate
P00005    YoManufacturer    yo0217mpn5        Manufacturer Part    Alternate
P00006    YoManufacturer    yo0217mpn6        Manufacturer Part    Alternate
P00007    YoManufacturer    yo0217mpn7        Manufacturer Part    Alternate
P00008    YoManufacturer    yo0217mpn8        Manufacturer Part    Alternate
P00009    YoManufacturer    yo0217mpn9        Manufacturer Part    Alternate

...

P00067    YoManufacturer2    yo0217mpn67    Manufacturer Part    Preferred
P00068    YoManufacturer2    yo0217mpn68    Manufacturer Part    Preferred
P00069    YoManufacturer2    yo0217mpn69    Manufacturer Part    Preferred
P00070    YoManufacturer2    yo0217mpn70    Manufacturer Part    Preferred
P00071    YoManufacturer2    yo0217mpn71    Manufacturer Part    Preferred
P00072    YoManufacturer2    yo0217mpn72    Manufacturer Part    Preferred
P00073    YoManufacturer2    yo0217mpn73    Manufacturer Part    Preferred
P00074    YoManufacturer2    yo0217mpn74    Manufacturer Part    Preferred
P00075    YoManufacturer2    yo0217mpn75    Manufacturer Part    Preferred

4. Import Preference

Blank Data Action : Retain Data
Smart Rules Warning Violation Behavior : Accept objects
Multi Row Update Mode : Add/Update only
Redline mode behavior : All Items onto the change

5. Item > Approved Manufacturer List
6. Redline options : Use the following change for redlinining C00001
7. Map all the attribute including prefferred status
8. Validate
9. Import
10. Check C00001

Affected Items tab have 75 rows

11. Click row : P00001
12. Go to Manufacturers tab

Mfr. Name            Mfr. Part Number  Preferred Status
----------------------------------------------------------
YoManufacturer    yo0217mpn1                                  <========== no redline to Preferred Status column
YoManufacturer2  yo0217mpn1       Preferred              <========== new redline inserted

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.