My Oracle Support Banner

Import BOM Lines With Affected Items: "Multi Row Update Mode" Setting With "Complete Replace" Value: Redlines Data Incorrectly (Doc ID 2583666.1)

Last updated on SEPTEMBER 05, 2019

Applies to:

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

Symptoms

Actual Behavior

Imported BOM Lines With Affected Items: "Multi Row Update Mode" setting and with "Complete Replace" Redlines data incorrectly.

Expected Behavior

Expect the Import with Affected Items: "Multi Row Update Mode" setting and with "Complete Replace" to Redline data correctly.

The issue can be reproduced at will with the following steps:
1. Login to WebClient
2. Click on Tools > Import
3. Import file: Items.xls

Number          DESCRIPTION    REV       Lifecycle Phase      Part Type    .....          
TEST10.0        XXXXXXXXX       AG          Active                    Material Part   ....      


4. Item Only
5. Data Mapping Use a saved Item_mapping file
6. Mapping file ItemsMapping.xml
7. Data Transformation: No transformations are necessary
8. Redline Options: Use the following Change for redlining TEST001 
    Item Import Complete

1. Run New Import
    Import Preference
    Business Rule
    Multi Row Update Mode: Complete Replace
2. Import File: bom.xls

PARENT_NUMBER    CHILD_NUMBER           ITEM_SEQ        REF_DES                REF_DES_DESCRIPTION            QUANTITY         PLANNING_FACTOR

TEST10.0              TEST10.0AL                    1                                                                                                          1                              100
TEST11.0              TEST11.0AL                    1                                                                                                          1                              100
TEST12.0              TEST12.0AL                    2                                                                                                          1                              100
TEST10.0              TEST10.0DG                   2                                                                                                          1                              100
TEST11.0              TEST11.0DG                   2                                                                                                          1                              100
TEST12.0              TEST12.0DG                   2                                                                                                          1                              100
TEST10.0              TEST26.1                        3                                                                                                         1                              100
TEST11.0              TEST26.1                        3                                                                                                         1                              100
TEST12.0              TEST26.1                        3                                                                                                         1                              100
TEST10.0              TEST54                           4                                                                                                  0.109                              100
TEST11.0              TEST54                           4                                                                                                  0.109                              100
TEST12.0              TEST54                           4                                                                                                  0.109                              100

 

3. Bill of Material
4. Data Mapping Use a saved bom_mapping file
6. Mapping file ItemsMapping.xml
7. Data Transformation: No transformations are necessary
8. Redline Options: Use the following Change for redlining TEST001

TEST001 Affected Items

Redlines for TEST10.0
BOM Tab
Item Number  Item Description   Item Rev   UOM Qty     Find Num 
TEST10.0AL     XXXXXXXXXX           AC                   1            1   --> Should Not be RED LINED - Not Correct
TEST10.0DG    XXXXXXXXXX           AC                   1            2   
TEST26.0         XXXXXXXXXX           AA           EA    1            3   --> RED LINED with the replacement data below - Correct
*Replace data --> TEST26.1                         EA     1            3 
TEST54            XXXXXXXXXX                           m     0.10      4   --> Imported the data with no changes - Correct

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
Cause
Solution


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