Concurrent Request LOVs Require Long time to Populate (Doc ID 2494423.1)

Last updated on MAY 04, 2019

Applies to:

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

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