|Update party Site [message #587984]
||Wed, 19 June 2013 12:02
Registered: June 2013
I am currently working on updating party sites using standard update API , hz_party_site_v2pub.update_party_site.
I ran the hz_party_site_v2pub.update_party_site API. We have some 14K sites that will get updated with this API.
I have created this update process as a concurrent request. So when I've submitted this Concurrent request another standard request "DQM Serial Sync Index Program (DQM Serial Sync Index Program)" is been submitted several times .I guess at least for 10 API updates 1 DMQ request is been submitted.
Is this fine ? or any action needed from my side ?
In the update API I have some thing like below..
l_init_msg_list VARCHAR2 (1000) := fnd_api.g_true;
x_total_cnt NUMBER := 0;
x_total_scs NUMBER := 0;
x_total_err NUMBER := 0;
x_conc_request_id NUMBER := fnd_global.conc_request_id ;
l_party_site_rec.party_site_id := c_site_store_num_rec.party_site_id;
l_party_site_rec.attribute2 := c_site_store_num_rec.customer_store_num;
l_party_site_rec.created_by_module := 'CUSTOMER_INTERFACE';
x_ver_number := c_site_store_num_rec.object_version_number;
Any pointers ?
[Updated on: Wed, 19 June 2013 12:06]
Report message to a moderator