My Oracle Support Banner

Turkey Localization: Performance Issues in Process CLE: Process AP Exchange Rate Differences in Preview Mode (Doc ID 2535935.1)

Last updated on AUGUST 14, 2019

Applies to:

EMEA Add-on Localizations - Version 12.1 and later
Information 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


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