My Oracle Support Banner

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:

Oracle Inventory Management - Version 12.2.3 and later
Information in this document applies to any platform.


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);


To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

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