Turkey Localization: Performance Issues in Process CLE: Process AP Exchange Rate Differences in Preview Mode
(Doc ID 2535935.1)
Last updated on AUGUST 13, 2021
Applies to:
EMEA Add-on Localizations - Version 12.1 and laterInformation in this document applies to any platform.
Symptoms
Reported Issue
-----------------
CLE: 'Process AR Exchange Rate Differences' program is having performance issue
STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Run the 'CLE: Process AR Exchange Rate Differences' program in Preview mode.
2. Observe that program is running for long and taking hours to complete.
Trace shows following sql being slow:
SELECT CEDD.CREATEERDIFFINV
FROM
CLE_ER_DFF_EXT CEDE ,CLE_ER_DFF_DFV CEDD WHERE CEDE.ROWID = CEDD.ROW_ID AND
CEDE.DFF_ID1 = :B2 AND CEDE.DFF_ID2 = :B1 AND CEDE.DFF_ID3 = 'V'
Changes
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 |
Changes |
Cause |
Solution |
References |