Performance In iProcurement Checkout Takes Several Minutes Or Gives Internal Server Error
(Doc ID 1938416.1)
Last updated on APRIL 20, 2023
Applies to:
Oracle iProcurement - Version 12.1.3 and laterInformation 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
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 |