This discussion is archived
13 Replies Latest reply: Oct 2, 2013 10:02 PM by user483 RSS

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

user8918217 Newbie
Currently Being Moderated

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.

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points