Cost Management: 'Copy Cost Across Organization' Has Slow Performance (Doc ID 1528360.1)

Last updated on FEBRUARY 04, 2017

Applies to:

Oracle Cost Management - Version 12.1.3 and later
Information in this document applies to any platform.

Symptoms

On : 12.1.3 version, Performance

ACTUAL BEHAVIOR
---------------
Copy Cost Across Organization for single Item is running very slow on our instance.

Seeing performance similar to below:

---- R12 Instance: Average : 3 to 15 minutes

---- 11i comparison: The 'Copy cost across organization' for single item in Production Instance completes in 5 to 10 seconds.

The following query appears to be slowing the process significantly:

INSERT INTO CST_UOM_CONV_RATES_TEMP ......SELECT src.inventory_item_id,......
FROM mtl_system_items_kfv src,mtl_system_items_b dst ....src.primary_uom_code
<> dst.primary_uom_code

EXPECTED BEHAVIOR
-----------------------
“Copy Item Costs across Organization” Program must complete in an acceptable time.

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