Mass Edit Actual Material Costs Fails with Log File Messages, Performance Issues (Doc ID 215045.1)

Last updated on MARCH 09, 2016

Applies to:

Oracle Cost Management - Version 11.5.5 to 11.5.10.3 [Release 11.5]
Information in this document applies to any platform.
CMCMEC- Mass Edit Cost Information
CMCCOC - Copy Item Costs Across Organizations
CMCICU - Update Standard Costs
CMRICU - Report Pending Cost Adjustments

Symptoms

Mass Edit Actual Material Costs fails with log file messages
Unable to obtain a lock on table CST_ITEM_COSTS
ORA-01555: snapshot too old: rollback segment number nnn with name "xxxxx" too small
Mass Edit Actual Material Costs is experiencing consistent performance degradation.
Other programs such as the CMCCOC (copy item cost), CMCICU (standard cost update) and CMRICU (simulate standard cost update) are running slowly

Changes

Mass Edit Actual Material Costs (CMCMEC) is consistently running too long so you frequently cancel the program. You have canceled other programs such as the CMCCOC (copy item cost), CMCICU (standard cost update) and CMRICU (simulate standard cost update) because they run slowly.

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