My Oracle Support Banner

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

Last updated on MARCH 25, 2019

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

To view full details, sign in with your My Oracle Support account.

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


In this Document
Symptoms
Cause
Solution
References


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