Performance In iProcurement Checkout Takes Several Minutes Or Gives Internal Server Error (Doc ID 1938416.1)

Last updated on AUGUST 25, 2017

Applies to:

Oracle iProcurement - Version 12.1.3 and later
Information in this document applies to any platform.

Symptoms

On Release 12.1.3

Find the performance issue when navigating to checkout. Also, the Internal Server Error can occur when executing checkout if the profile Account Generator:Run in Debug Mode is set.

The statements taking longer to execute are like:

begin fnd_log_repository.get_bulk_context_pvt(:1, :2, :3, :4, :5); end;


call     count       cpu    elapsed       disk      query    current        rows
------- ------  -------- ---------- ---------- ---------- ----------  ----------
Parse        0      0.00       0.00          0          0          0           0
Execute  32907     41.67      42.14          0          0          0       32907
Fetch        0      0.00       0.00          0          0          0           0
------- ------  -------- ---------- ---------- ---------- ----------  ----------
total    32907     41.67      42.14          0          0          0       32907

SELECT VALUE
FROM
V$PARAMETER WHERE NAME = 'utl_file_dir'


call     count       cpu    elapsed       disk      query    current        rows
------- ------  -------- ---------- ---------- ---------- ----------  ----------
Parse       66      0.00       0.00          0          0          0           0
Execute   2567      0.26       0.22          0          0          0           0
Fetch     2567     11.38      11.37          0          0          0        2567
------- ------  -------- ---------- ---------- ---------- ----------  ----------
total     5200     11.64      11.59          0          0          0        2567


SQL ID: 7q2muqzu9xdtj Plan Hash: 0

begin PO_WF_PO_CHARGE_ACC.validate_combination (:v1, :v2, :v3, :v4, :v5);
 end;


call     count       cpu    elapsed       disk      query    current        rows
------- ------  -------- ---------- ---------- ---------- ----------  ----------
Parse        4      0.00       0.00          0          0          0           0
Execute      4      2.11       9.12          0          0          0           4
Fetch        0      0.00       0.00          0          0          0           0
------- ------  -------- ---------- ---------- ---------- ----------  ----------
total        8      2.11       9.12          0          0          0           4


begin FND_FLEX_WORKFLOW_APIS.VALIDATE_COMBINATION (:v1, :v2, :v3, :v4, :v5);
 end;


call     count       cpu    elapsed       disk      query    current        rows
------- ------  -------- ---------- ---------- ---------- ----------  ----------
Parse        4      0.00       0.00          0          0          0           0
Execute      4      1.27       5.85          0          0          0           4
Fetch        0      0.00       0.00          0          0          0           0
------- ------  -------- ---------- ---------- ---------- ----------  ----------
total        8      1.27       5.85          0          0          0           4

Note the high elapsed time.

 


Expected Behaviour
No performance issues.

STEPS TO REPRODUCE
The issue can be reproduced at will with the following steps.
1. Login to iProcurement user responsibility
2. Select an item
3. Click on checkout ->> It takes several minutes (more than 5 mins) or it can crash with "Internal Server 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