Requisition Import(REQIMPORT) Process Slow performance issue (Doc ID 1631101.1)

Last updated on MARCH 02, 2023

Applies to:

Symptoms

Requisition Import takes a long time to complete.

Steps to Reproduce :

1. Navigate to Purchasing responsibility>Request>Run.

2.Submit "Requisition Import" concurrent program.

3. It takes a long time to complete as below:
  If requisition record count is 3000, it will run around 30 minutes.
  However, if the requisition record count is greater than 3000, e.g. 5000, then it will cost about 80 minutes.

4.Per Trace File, below SQL is he most expensive query:
 
update po_requisitions_interface set requisition_header_id=:b0
where
((req_number_segment1=:b1 and request_id=:b2) and process_flag<>'ERROR')

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.