My Oracle Support Banner

Populate UWQ Summary Updates in 15 Minutes but Completes in 1 Hour (Doc ID 1137113.1)

Last updated on FEBRUARY 07, 2017

Applies to:

Oracle Advanced Collections - Version 12.1.2 and later
Information in this document applies to any platform.

Symptoms

The Concurrent Program 'IEX: Populate UWQ Summary Table' performs the refresh of the summary table in 15 minutes for less than 70k records, but request itself completes in 1 hour.
 
 

SQL
-------
 
SELECT STRAT.JTF_OBJECT_ID, WKITEM.WORK_ITEM_ID, WKITEM.SCHEDULE_START
SCHEDULE_START, WKITEM.SCHEDULE_END SCHEDULE_END,
STRY_TEMP_WKITEM.CATEGORY_TYPE CATEGORY, STRY_TEMP_WKITEM.WORK_TYPE,
STRY_TEMP_WKITEM.PRIORITY_TYPE, WKITEM.RESOURCE_ID, WKITEM.STRATEGY_ID,
STRAT.STRATEGY_TEMPLATE_ID, WKITEM.WORK_ITEM_TEMPLATE_ID,
WKITEM.STATUS_CODE, STRAT.STATUS_CODE, WKITEM.EXECUTE_START START_TIME,
WKITEM.EXECUTE_END END_TIME, WKITEM.WORK_ITEM_ORDER WKITEM_ORDER,
WKITEM.ESCALATED_YN
FROM
IEX_STRATEGIES STRAT, IEX_STRATEGY_WORK_ITEMS WKITEM,
IEX_STRY_TEMP_WORK_ITEMS_B STRY_TEMP_WKITEM, IEX_DLN_UWQ_SUMMARY SUM WHERE
STRAT.JTF_OBJECT_TYPE = 'IEX_BILLTO' AND STRAT.STATUS_CODE IN('OPEN',
'ONHOLD') AND WKITEM.STRATEGY_ID = STRAT.STRATEGY_ID
AND WKITEM.STATUS_CODE IN('OPEN', 'ONHOLD') AND
WKITEM.WORK_ITEM_TEMPLATE_ID = STRY_TEMP_WKITEM.WORK_ITEM_TEMP_ID AND
STRAT.JTF_OBJECT_ID = SUM.SITE_USE_ID
AND sum.LAST_UPDATE_DATE >= trunc(sysdate)
AND SUM.ORG_ID=NVL(:B2 ,SUM.ORG_ID) AND SUM.BUSINESS_LEVEL='BILL_TO';

Changes

<Patch 9487600>

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
Changes
Cause
Solution
 1. Bug Summary
 2. Fixed Files
 3. Recommended Patches
 4. Solution Steps
References


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