4 Replies Latest reply: Dec 7, 2009 2:34 PM by dwright_nz RSS

    reg : mtl_item_categories_interface

    711587
      Hi all,
      I am trying to upload data into inventory thru use of interface any api.
      what i did is i created a temporary staging table and added data to it then moved the data to MTL_ITEM_CATEGORIES_INTERFACE .noW trying to move this data to base tables by using pl./sql code ,apis and seeded programs. But unsucceessful .

      Could anybody give me a possible solution to do the same
        • 1. Re: reg : mtl_item_categories_interface
          676522
          Hi,

          Once you run the "Import Items" seeded program what's the error you are facing i mean any error messages in the Log file?.

          And also in the interface you can see the error message column for what reason it has failed to load into base tables.

          Thanks,
          Raghav
          • 2. Re: reg : mtl_item_categories_interface
            584394
            Please find the navigation for importing Item Categories from interface table to base table.

            Inventory>Items>Import>Import Item Category Assignments.


            This should create item categories in inventory.


            HTH

            DineshS
            • 3. Re: reg : mtl_item_categories_interface
              714377
              Hi before using the mtl_item_categories_interface you have load all the ietms into inv with the help of mtl_system_items_interface when you do this automatically a default category id and category set_id will be assigned to the loaded items. so when you try to insert it wont take it. instead you have to update the category and category set id if necesaary..so the status should be update and you should provide the defalut category and category set id and along with the desired category id and category set id which you wish to populate. still facing the issue post me ur code I will correct it as i already did this conversions
              • 4. Re: reg : mtl_item_categories_interface
                dwright_nz
                have a look at the more4apps item wizard, this would be an ideal tool to load categories.