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

Last updated on OCTOBER 12, 2016

Applies to:

Oracle Purchasing - Version 12.1.3 to 12.2 [Release 12.1 to 12.2]
Information in this document applies to any platform.

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

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms