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.
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
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!