Requisition Import performance is very slow , it is taking 38 hours to process 50k records
When we ran the requisition import program it took 38 hours to process 50k records.
Please let me know how to improve on its performance.
We are triggering the requisition by using "fnd_request.submit_request"
Fnd_Global.apps_initialize(g_user_id,
g_resp_id,
g_resp_appl_id);
mo_global.init ('PO');
lv_request_id_num := fnd_request.submit_request(application => 'PO',
program => 'REQIMPORT',
description => NULL,
start_time => SYSDATE,
sub_request => FALSE,
argument1 => p_l_INTERFACE_SOURCE_CODE_in , ,
argument2 => p_l_batch_id_in --null -- BATCH ID
,
argument3 => 'ITEM' --GROUP ID
,
argument4 => NULL -- LAST_REQUISITION NUMBE