Data in BOM_STRUCTURES_B with PK1_VALUE and assembly_item_id as null
Hi experts
When upgrade from 11.5.10 to R12, error out: duplicate BOM data in BOM_STRUCTURES_B , run below script
select * from BOM.BOM_STRUCTURES_B where obj_name is null and pk1_value is null
and pk2_value=84 and ALTERNATE_BOM_DESIGNATOR is null;
ASSEMBLY_ITEM_ID ORGANIZATION_ID COMMON_BILL_SEQUENCE_ID BILL_SEQUENCE_ID
                                                 84                                      45449                                 45449
                                                 84                                       81427                                  81427
                                                 84                                      123593                                  123593
                                                 84                                      126708                                   126708
                                                 84                                      133468                                   133468
                                                 84                                      133972                                     133972
                                                84                                        134499                                    134499
                                                 84                                       135564                                    135564
created_by are populated , user of created_by only have Inquery BOM responsibility, cannot update/create BOM.
My question: Where these datas came from? Which action can populate data into this table?
From bug 5919292, I know that upgrad will populate data into BOM_STRUCTURES_B .
