My Oracle Support Banner

CMCMCW - Material Cost Transaction Performance Issue (Doc ID 1380206.1)

Last updated on DECEMBER 04, 2019

Applies to:

Oracle Cost Management - Version 12.1.1 and later
Information in this document applies to any platform.
Executable: CMCMCW - Material Cost Transaction Worker


Symptoms

ISSUE CLARIFICATION
------------------

CMCMCW - Material Cost Transaction Worker is running slow, performance issue.

 

ISSUE VERIFICATION
------------------

 

Following EBS seeded source code is running slow:

SELECT CCE.PARENT_EVENT_ID PRIOR_EVENT_ID, CCE.COGS_PERCENTAGE,
SUM(CCE.EVENT_QUANTITY) PRIOR_EVENT_QUANTITY FROM CST_COGS_EVENTS CCE
WHERE :B2 = CCE.COGS_OM_LINE_ID AND CCE.EVENT_DATE <= :B1 AND
CCE.PARENT_EVENT_ID NOT IN (SELECT PRIOR_EVENT_ID FROM CST_COGS_EVENTS
WHERE EVENT_DATE <= :B1 AND COGS_OM_LINE_ID <= :B2 AND
PRIOR_EVENT_ID IS NOT NULL) GROUP BY CCE.PARENT_EVENT_ID,
CCE.COGS_PERCENTAGE

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.