1 Reply Latest reply on Nov 10, 2009 9:26 AM by S.PDASH

    Item Catalogue and Manufacturing part numbers to the items

    609426
      Dear All,

      How can I introduce the Item Catalogue and Manufacturing part numbers to the items already defined in inventory.., which currently does not have this?

      the purpose of doing this is I would like to project to the customers the Item with Catalogue number, but internally it may have different or varying part numbers

      I have around 15000 items, how can i do this with a best and ideal approach..

      Please update..

      Many Thanks in advance....
        • 1. Re: Item Catalogue and Manufacturing part numbers to the items
          S.PDASH
          Hi,
          We assume that you have already defined Item Catalogue & manufacturer Part number in your system before you are assigning it to Items. Best approach will be, Update the items with Item catalogue / MFG part Number either through API or conversion program..

          e.g.
          *1) Insert/Populate Item (existing Item) info in interface table*

          INSERT INTO MTL_SYSTEM_ITEMS_INTERFACE
          (SEGMENT1,
          ORGANIZATION_CODE,
          TRANSACTION_TYPE,
          PROCESS_FLAG,
          SET_PROCESS_ID,
          DESCRIPTION,
          PRIMARY_UOM_CODE,
          TEMPLATE_NAME)
          VALUES
          ('AS_TEST_ITEM_01',
          'XYZ', --- inv org code
          'UPDATE',
          1,
          232485, --- set process id
          'Test Item',
          'EA',
          Test Item')

          *2) Run Item import*
          (Navigation : Inventory Resp --> Items --> Import --> Import Items)

          Hope this will help.

          Regards :)
          S.P DASH