Improve Performance Of 'Update Standard Costs' CMCICU (Doc ID 750331.1)

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***

Symptoms

While 'Update Standard Costs' is running, statistic information is being changed and updated by the below code inside the program all the time.

' begin fnd_stats . gather_table_stats ( :l_schema , 'CST_LISTS_TEMP' ) ;
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'

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