IB UPDATE_ITEM_INSTANCE ERROR - doesn't allow ACTIVE_START_DATE to change
336471Sep 15 2008 — edited Mar 5 2009All,
I need to update active_start_date of IB instance. I have written a test program to update active_start_date using
csi_item_instance_pub.update_item_instance API. After running the script, I am
getting following error:
Msg1: Installed Base doesn't allow ACTIVE_START_DATE to be changed
x_return_status = E
x_msg_count = 1
x_msg_data = Installed Base doesn't allow ACTIVE_START_DATE to be changed
Question:
Is ACTIVE_START_DATE really is not allowed to be updated using update_item_instance API ? What's the
reason ?
Is there any program code issue in the script that is causing this error ?
What are other alternatives ?
Thanks
-- this is the sample code I have used --
BEGIN
x_instance_rec.instance_id := 10028 ;
x_instance_rec.object_version_number := 1;
p_txn_rec.transaction_id := FND_API.G_MISS_NUM;
p_txn_rec.transaction_date := SYSDATE;
p_txn_rec.source_transaction_date := SYSDATE;
p_txn_rec.transaction_type_id := 1;
x_instance_rec.active_start_date := to_date('5/4/1998','mm/dd/yyyy') ; --SYSDATE;
x_instance_rec.install_date := SYSDATE ; to_date('5/4/1998','mm/dd/yyyy') ;
--P_ext_attrib_values(0).instance_id := 70146;
--P_ext_attrib_values(0).attribute_id := 10165;
--P_ext_attrib_values(0).attribute_value := 'TEST';
csi_item_instance_pub.update_item_instance(
1.0,
p_commit,
p_init_msg_lst,
1,
x_instance_rec,
p_ext_attrib_values,
p_party_tbl,
p_account_tbl,
p_pricing_attrib_tbl,
p_org_assignments_tbl,
p_asset_assignment_tbl,
p_txn_rec,
x_instance_id_lst,
x_return_status,
x_msg_count,
x_msg_data);
commit;
-- Output the results
if x_msg_count > 0 then
for j in 1 .. x_msg_count
loop
fnd_msg_pub.get ( j , FND_API.G_FALSE , x_msg_data , t_msg_dummy );
t_output := ( 'Msg' || To_Char ( j ) || ': ' || x_msg_data );
dbms_output.put_line ( SubStr ( t_output , 1 , 255 ) );
end loop;
end if;
dbms_output.put_line('x_return_status = '||x_return_status);
dbms_output.put_line('x_msg_count = '||TO_CHAR(x_msg_count));
dbms_output.put_line('x_msg_data = '||x_msg_data);
COMMIT;
END;