Unable To Update Mtl Lot Attributes Using API inv_lot_api_pub.update_inv_lot In Non-WMS Instances (Doc ID 3060924.1)

Last updated on NOVEMBER 26, 2024

Applies to:

Symptoms

When using inv_lot_api_pub.update_inv_lot to try and update lot attributes for a large number of records.

The api completes as successful but the lot attributes are not updated even when WMS is installed as per Bug 9819960 and confirming that this works without issue from the front end.

It is expected that c_attributes to should be updated even without WMS installed as long as no WMS attributes are updated.

Steps
1. Run API to update inv_lot_api_pub.update_inv_lot such as the following example:

  v_lot_record.C_ATTRIBUTE3 := '12345';
  v_lot_record.N_ATTRIBUTE2 := 999999;
  v_lot_record.D_ATTRIBUTE1 := trunc(sysdate) - 60;
  v_lot_record.C_ATTRIBUTE10 := '10000';
  v_lot_record.N_ATTRIBUTE10 := 15;

dbms_output.put_line('inventory_item_id:' || v_lot_record.inventory_item_id);
dbms_output.put_line('organization_id:' || v_lot_record.organization_id);
dbms_output.put_line('lot_number:' || v_lot_record.lot_number);
-- dbms_output.put_line('status_id:' || v_lot_record.status_id);


inv_lot_api_pub.update_inv_lot(x_return_status => v_ret_status,
x_msg_count => v_msg_count,
x_msg_data => v_msg_data,
x_lot_rec => x_lot_record,
p_lot_rec => v_lot_record,
p_source => v_appl,
p_api_version => 1.0,
p_init_msg_list => fnd_api.g_true,
p_commit => fnd_api.g_false);



2. Find that the c_attributes are not updated.

Cause

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