CMCICU: Standard Cost Update Performance (Doc ID 1508811.1)

Last updated on MARCH 09, 2016

Applies to:

Oracle Cost Management - Version 12.1.3 to 12.1.3.3 [Release 12.1]
Information in this document applies to any platform.

Symptoms

CMCICU Update Standard Costs Program Poor Performance has performance issues, 60 minutes run instead of 20-25 minutes as usual



STEPS

1.Cost Management responsibility:
2. Costs
3. Run 'Update Standard Costs' Program.


Remark : 

As an improvement, a parameter in "Create Accounting - Cost Managment" has been changed.
CST_SRS_INV_ORG_OU parameter has been added with patch 14369192 which is part of 14371087 - POOR PERFORMANCE WITH STANDARD COST UPDATE PROGRAM
This new parameter is a minor security improvement. 

For more information about this parameter see: <Bug 14369192> MINOR ENHANCEMENT IN COSTING ACCOUNTING INTEGRATION WITH SLA ACCOUNTING SECURITY  

Changes

Resolution 
Added a function cst_del_cilt in package CSTPUPDT to delete from CST_ITEM_LIST_TEMP and use bulk processing to improve performance.

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