Inventory Management - EBS (MOSC)

MOSC Banner

Data in BOM_STRUCTURES_B with PK1_VALUE and assembly_item_id as null

edited May 8, 2013 10:18AM in Inventory Management - EBS (MOSC) 1 commentAnswered

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 .

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center