My Oracle Support Banner

Update Standard Costs Cmcusiq() Failed Due To ORA-20005 CMCICU: Error Processing In Main Bad Performance executing (Doc ID 2093273.1)

Last updated on SEPTEMBER 10, 2018

Applies to:

Oracle Cost Management - Version 12.2.3 and later
Information in this document applies to any platform.
***Checked on Relevance on 07/AUG/2017 ****

Symptoms

On : 12.2.3 version, Cost Maintenance

ACTUAL BEHAVIOR
---------------

Update Standard Costs Program (CMCICU) Ending in Error

Provided Solution was to Delete and Lock the stats on below temp tables.

exec DBMS_STATS.DELETE_TABLE_STATS ( ownname => 'BOM', tabname=>'CST_CG_LIST_TEMP');
exec DBMS_STATS.DELETE_TABLE_STATS ( ownname => 'BOM', tabname=>'CST_ITEM_LIST_TEMP');
exec DBMS_STATS.DELETE_TABLE_STATS ( ownname => 'BOM', tabname=>'CST_SUB_LIST_TEMP');
exec DBMS_STATS.DELETE_TABLE_STATS ( ownname => 'BOM', tabname=>'CST_INV_QTY_TEMP');
exec DBMS_STATS.DELETE_TABLE_STATS ( ownname => 'BOM', tabname=>'CST_INV_COST_TEMP');

exec dbms_stats.lock_table_stats('BOM', 'CST_CG_LIST_TEMP');
exec DBMS_STATS.lock_table_stats( ownname => 'BOM', tabname=>'CST_ITEM_LIST_TEMP');
exec DBMS_STATS.lock_table_stats( ownname => 'BOM', tabname=>'CST_SUB_LIST_TEMP');
exec DBMS_STATS.lock_table_stats( ownname => 'BOM', tabname=>'CST_INV_QTY_TEMP');
exec DBMS_STATS.lock_table_stats( ownname => 'BOM', tabname=>'CST_INV_COST_TEMP');


After Executing these Steps Update standard Cost program is going in to error.
Attached are the Log files.



STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Cost Management
2. Submit
3. Update Standard Costs


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


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