Cost Management: 'Copy Cost Across Organization' Has Slow Performance
Last updated on FEBRUARY 21, 2018
Applies to:Oracle Cost Management - Version 12.1.3 and later
Information in this document applies to any platform.
On : 12.1.3 version, Performance
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
“Copy Item Costs across Organization” Program must complete in an acceptable time.
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