CMCICU Standard Cost Update Poor Performance or not Completing
(Doc ID 234023.1)
Last updated on JUNE 03, 2024
Applies to:
Oracle Cost Management - Version 11.5 and laterInformation in this document applies to any platform.
Standard Cost Update - CMCICU
*** Checked on Relevance on 02-AUG-2018 ***
Purpose
The update standard cost process is perhaps one of the most used processes within Oracle Cost Management.
1. Tools to help diagnose a performance problem.
a. Currently the only tool used by support and development to help diagnose a performance issue is a database level trace. See <> for detailed information on a SQL Trace.
b. The following lists the most common tables where performance issues arise:
1) CST_STD_COST_ADJ_TEMP
2) CST_STD_COST_ADJ_VALUES
3) WIP_SCRAP_VALUES
4) CST_ITEM_COSTS
5) CST_LISTS
2) CST_STD_COST_ADJ_VALUES
3) WIP_SCRAP_VALUES
4) CST_ITEM_COSTS
5) CST_LISTS
Troubleshooting Steps
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |