Skip to Main Content

E-Business Suite

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

IB UPDATE_ITEM_INSTANCE ERROR - doesn't allow ACTIVE_START_DATE to change

336471Sep 15 2008 — edited Mar 5 2009
All,

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;

Comments

Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Apr 2 2009
Added on Sep 15 2008
11 comments
2,957 views