CMCICU Update Standard Costs Performance Is Poor (Doc ID 471868.1)

Last updated on MARCH 08, 2017

Applies to:

Oracle Cost Management - Version 11.5.10.2 to 11.5.10.3 [Release 11.5]
Information in this document applies to any platform.

Symptoms

On 11.5.10.2 in Production:
Users are running Update standard costs (CMCICU) , this has been active for 48 hrs +.

This process has run essentially stand-alone for the entire 48 hours.

Users are currently executing the following statement:


insert into
cst_std_cost_adj_temp(transaction_type,source_type,organization_id,inventory_item_id,wip_entity_id,a
djustment_quantity,transaction_id)select 4 ,1 ,WDJ.organization_id ,WDJ.primary_item_id
,WDJ.wip_entity_id ,WDJ.quantity_completed ,TO_NUMBER(null ) from wip_accounting_classes WAC
,cst_item_costs_temp CICT ,wip_discrete_jobs WDJ where ((((((WDJ.organization_id=:b0 and
WDJ.primary_item_id=CICT.inventory_item_id) and WDJ.status_type between 3 and 7) and
WDJ.quantity_completed<>0) and WAC.organization_id=WDJ.organization_id) and
WAC.class_code=WDJ.class_code) and WAC.class_type in (1,3,5)) union all select 4 ,2
,MMT.organization_id ,MMT.inventory_item_id ,WDJ.wip_entity_id ,(MMT.primary_quantity* (-1))
,MMT.transaction_id from cst_item_costs_temp CICT ,wip_discrete_jobs WDJ ,wip_accounting_classes
WAC ,mtl_material_transactions MMT where ((((((((((MMT.costed_flag in ('E','N') and
MMT.organization_id=:b0) and MMT.transaction_source_type_id=5) and MMT.transaction_action_id in
(31,32)) and CICT.inventory_item_id=MMT.inventory_item_id) and
WDJ.organization_id=MMT.organization_id) and WDJ.wip_entity_id=MMT.transaction_source_id) and
WDJ.status_type between 3 and 7) and WAC.organization_id=WDJ.organization_id) and
WAC.class_code=WDJ.class_code) and WAC.class_type in (1,3,5))

EXPECTED BEHAVIOR
Expect CMCICU run normally .

STEPS
The issue can be reproduced at will with the following steps:
Run cost rollup.
Submit CMCICU via Concurrent request

.

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