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

Last updated on AUGUST 07, 2017

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

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