CSTRCMCR Collect Revenue Recognition Information performance MERGE INTO CST_REVENUE_RECOGNITION_LINES (Doc ID 744763.1)

Last updated on JANUARY 22, 2017

Applies to:

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

Symptoms

When you are running the CSTRCMCR Collect Revenue Recognition Information and CSTRCMCR3 Generate COGS Recognition Events programs, there is a performance problem in the following SQL statement:

MERGE INTO CST_REVENUE_RECOGNITION_LINES CRRL USING ( SELECT REV.SO_LINE_ID,
MAX(REV.LATEST_GL_DATE) GL_DATE, GPS.EFFECTIVE_PERIOD_NUM PERIOD_NUMBER


Steps To Reproduce:
The issue can be reproduced at will with the following steps:

1. Oracle cost management
2. Run the following programs

a. CSTRCMCR1 Record Order Management Transactions
b.Run CSTRCMCR Collect Revenue Recognition Information program
c. Run CSTRCMCR3 Generate COGS Recognition Events

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