13 Replies Latest reply on Oct 3, 2013 5:02 AM by user483

    Oracle Inventory - Update Full Lot Controlled Item to No Lot Control through interface


      We are trying to update lot control status of few items and below are the details


      Item A - Lot Control is Full Controlled / Lot Status Enabled is set as Yes and Default Lot Status id is set as Active.


      Requirement is update as Lot Control - No Lot Control , Lot Status Enabled - No and Default Lot Status Id - null.


      We are trying to insert the values in MTL_SYSTEM_ITEMS_INTERFACE with lot_control_code = 1, lot_status_enabled = N and default_lot_status_id = NULL but getting an error that Default Lot Status can be enabled to only Lot Enabled Items.


      The combination being passed is valid as per Oracle functionality but no idea why the failure. Thanks in advance.