Improve Performance Of 'Update Standard Costs' CMCICU
Last updated on FEBRUARY 09, 2017
Applies to:Oracle Cost Management - Version 12.0.0 and later
Information in this document applies to any platform.
***Checked for relevance on 09-FEB-2017***
While 'Update Standard Costs' is running, statistic information is being changed and updated by the below code inside the program all the time.
fnd_stats . gather_table_stats ( :l_schema , 'CST_ITEM_LIST_TEMP' ) ; END ;'
Run-Time execution plan might be changed according to statistic information of CST_LISTS_TEMP table that is generated during Run-Time. When things come to the worst, the program executes with MERGE JOIN (CARTESIAN) execution plan.
It causes performance issue and slow response time.
Therefore, the customer asks to change the program for the better using, for example, SQL Hint instead of MERGE JOIN (CARTESIAN).
The issue can be reproduced at will with the following steps:
1.Cost Manager responsibility: Run 'Update Standard Costs'
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms