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 JULY 06, 2018

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
ALN    07-->red-line to 00                  100           CN1234              Cap            0.024-->red-line to 9
ALN    06-->red-line to 00                  200           WSP                   Water         12.312-->red line to 9
ALN    07-->red-line to 00                  300           PB1                    Pallet          0.0119-->red line to 10

But the import file is:
FG|SITE|LINE|SEQ|COMP|COMP SITE|QTY
BGY05|ALN|00|100|CN1234|ALN|9
BGY05|ALN|00|200|WAT|ALN|9
BGY05|ALN|00|300|PAL|ALN|10

Customer wants to get the following result:
Site   ProductLine(s)   Item Seq   Item Number    ItemType           Qty
ALN   00                    100           CN1234            Cap                   0.024-> red line to 9
ALN   00                    200           WAT                 Water                12.312-->red line to 9
ALN   00                    300           PAL                  Pallet                 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!


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