Issues with table locks on FND_CACHE_VERSIONS in R12
Last updated on AUGUST 08, 2017
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.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms