Issues with table locks on FND_CACHE_VERSIONS in R12
(Doc ID 1921174.1)
Last updated on FEBRUARY 01, 2019
Applies to:Oracle Application Object Library - Version 12.1.3 to 12.1.3 [Release 12.1]
Information in this document applies to any platform.
On E-Business Suite (EBS) Release 12.1.X,
huge performance issues are caused by the following query:
UPDATE FND_CACHE_VERSIONS SET VERSION = VERSION + 1 WHERE NAME = :B1
Caused enq: TX - row lock contention on database impacting the EBS Performance.
This query can be executed by multiple business transactions and events by various modules.
The issue can be reproduced at will with the following steps:
1. Log into EBS
2. Switch to OTL responsibility.
3. Create a new time card from default 'Last Timesheet' or with 3 predefined projects.
4. Save Timecard.
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