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 later
Information in this document applies to any platform.
CLE: 'Process AR Exchange Rate Differences' program is having performance issue
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:
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'
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