Concurrent Request LOVs Require Long time to Populate
(Doc ID 2494423.1)
Last updated on DECEMBER 03, 2019
Applies to:
Oracle Cost Management - Version 12.2.4 and laterInformation in this document applies to any platform.
Symptoms
On : 12.2.4 version, MICC Transfer to TSC
ACTUAL BEHAVIOR
---------------
Supply Chain Cost rollup LOV which lists the different cost rollup programs take a min to populate
Cost Management->Supply Chain Costing->Supply CHain cost rollup->Single Request->OK
Click on the list of values to show the programs available and results come back after 1-2 mins
EXPECTED BEHAVIOR
-----------------------
Expect this to populate in short order
SLOWDOWN QUERY:
==================
select distinct p.user_concurrent_program_name, a.application_id,
a.application_name, a.application_short_name, p.concurrent_program_name,
p.concurrent_program_id, p.application_id program_application_id,
'$SRS$.'||p.concurrent_program_name descriptive_flexfield_name, p.srs_flag,
p.printer_name, p.output_print_style, p.required_style, p.save_output_flag,
p.nls_compliant, p.execution_method_code, p.mls_executable_id,
p.mls_executable_app_id, p.multi_org_category, null operating_unit, null
org_id
from
fnd_concurrent_programs_vl p, fnd_application_vl a, fnd_request_group_units
u where p.srs_flag in ('Y', 'Q') and p.enabled_flag = 'Y' and
request_set_flag = 'N' and ((a.application_id = u.unit_application_id and
u.application_id = :1 and u.request_group_id = :2 and u.request_unit_type =
'A') or (p.application_id = u.unit_application_id and
p.concurrent_program_id = u.request_unit_id and u.application_id = :3 and
u.request_group_id = :4 and u.request_unit_type = 'P')) and
(((p.security_group_id is null or p.security_group_id = :5) and (:6 = 'Y'))
or (:7 != 'Y')) and p.application_id = a.application_id order by
a.application_name, p.user_concurrent_program_name
call count cpu elapsed disk query current rows
------- ------ -------- ---------- ---------- ---------- ---------- ----------
Parse 1 0.00 0.00 0 0 0 0
Execute 1 0.05 0.05 0 0 0 0
Fetch 1 106.66 106.99 403 1222 0 3
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total 3 106.72 107.05 403 1222 0 3
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 |