Procurement - EBS (MOSC)

MOSC Banner

Requisition Import performance is very slow , it is taking 38 hours to process 50k records

edited Nov 13, 2014 10:02AM in Procurement - EBS (MOSC) 13 commentsAnswered
Hi ,

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

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center