My Oracle Support Banner

Agile BOM Import Does Not Consider Production Line Value At A Site To Update Component (Doc ID 2417652.1)

Last updated on MARCH 11, 2019

Applies to:

Oracle Agile Product Collaboration - Version 9.3.3.0 and later
Information in this document applies to any platform.

Symptoms

Agile BOM Import does not consider production line value at a site to update component after Import.

A parent item has multiple BOM's at a plant which is specific to the production line. A plant has multiple lines and each line has a different bom with few items common to all lines. 
 

The issue can be reproduced at will with the following steps:
After imported the excel, will get the following results: (Note: the following is made up data)
Site    ProductLine(s)                         Item Seq   Item Number       ItemType    Qty
S1    07-->red-line to 00                  100           P12                    XX            0.024-->red-line to 9
S1    06-->red-line to 00                  200           P2                      YY         12.312-->red line to 9
S1    07-->red-line to 00                  300           P3                      ZZ          0.0119-->red line to 10

But the import file is:
FG|SITE|LINE|SEQ|COMP|COMP SITE|QTY
BGY05|S100|100|P1|S1|9
BGY05|S2|00|200|P2|S1|9
BGY05|S3|00|300|P3|S1|10

Customer wants to get the following result:
Site   ProductLine(s)   Item Seq   Item Number    ItemType           Qty
S1   00                    100           P1                      XX                   0.024-> red line to 9
S1   00                    200           P2                      YY                  12.312-->red line to 9
S1   00                    300           P3                      ZZ                  0.0119-->red line to 10

System should select the correct row of BOM according to the import file and just redline the QTY, but the actual result is that system doesn't select the correct BOM row and redline the ProductLine(s) and Qty.

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
References


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