Journal Import Performance Due to FND_FLEX_HASH Lock
(Doc ID 2408879.1)
Last updated on AUGUST 16, 2018
Applies to:Oracle General Ledger - Version 188.8.131.52 and later
Information in this document applies to any platform.
Journal import performance issue.
The trace file shows a deadlock:
SELECT HASH_VALUE FROM FND_FLEX_HASH WHERE HASH_VALUE = :B1 FOR UPDATE
The issue can be reproduced at will with the following steps:
1. Submit journal import.
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!