Home » Applications » Oracle Fusion Apps & E-Business Suite » Update party Site (R12.1)
Update party Site [message #587984] Wed, 19 June 2013 12:02 Go to next message
Messages: 1
Registered: June 2013
Junior Member

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;
l_party_site_rec apps.hz_party_site_v2pub.party_site_rec_type;
x_oracle_user_id NUMBER;
x_ver_number NUMBER;
x_status VARCHAR2(1);
x_return_status VARCHAR2(1);
x_message VARCHAR2(4000);
x_msg_data VARCHAR2(4000);
x_msg_count NUMBER;
x_resp_id NUMBER;
x_appl_id NUMBER;
x_total_cnt NUMBER := 0;
x_total_scs NUMBER := 0;
x_total_err NUMBER := 0;
x_rec_count NUMBER;
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;


more info..


Any pointers ?

[Updated on: Wed, 19 June 2013 12:06]

Report message to a moderator

Re: Update party Site [message #589077 is a reply to message #587984] Tue, 02 July 2013 00:38 Go to previous message
Messages: 18
Registered: May 2013
Location: Bangalore
Junior Member


With this DQM Concurrent Program(Calls Package HZ_DQM_SYNC.sync_index_serial) are you feeling any problem in updating of Sites?.
What is the issue for you if tat program is running.

As per my understanding its trying to create index on that table or you can check what is tat DQM Concurrent Program and its Activities.

Previous Topic: Frm-92101 Error in Application
Next Topic: OAF Problem
Goto Forum:

Current Time: Sat Jul 22 15:53:36 CDT 2017

Total time taken to generate the page: 0.14336 seconds