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 laterInformation 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 |