Is There any Open Interface For Mtl_lot_numbers to update Expiration Date (Doc ID 2395834.1)

Last updated on AUGUST 08, 2023

Applies to:

Goal

1)Is there any open interface for mtl_lot_numbers . If we have to update an expiration date on a lot with out associating with any transaction can we able to do it in an open interface.

2) If we use an API , its returning success but not updating the expiration date.

  inv_lot_api_pub.update_inv_lot (
  x_return_status => l_return_status,
  x_msg_count => l_msg_count,
  x_msg_data => l_msg_data,
  p_inventory_item_id => l_inventory_item_id,
  p_organization_id => l_organization_id,
  p_lot_number => l_lot_number,
  p_expiration_date => L_EXPIRATION_DATE,
  p_attributes_tbl => l_attributes_tbl,
  p_c_attributes_tbl => l_c_attributes_tbl,
  p_n_attributes_tbl => l_n_attributes_tbl,
  p_d_attributes_tbl => l_d_attributes_tbl,
  p_source => l_application_id);
 

Solution

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.