Impact of ICX:Session Timeout Profile Setting to Avoid HR_7165_OBJECT_LOCKED Error During Annual Benefits Enrollment in Self-Service

(Doc ID 753888.1)

Last updated on MAY 15, 2018

Applies to:

Oracle Advanced Benefits - Version and later
Information in this document applies to any platform.


During annual Open enrollment, the following message is received by several employees a day:

ORA-20001: HR_7165_OBJECT_LOCKED: N, TABLE_NAME, ben_prtt_enrt_rslt_f
Cause: An unexpected Oracle error has occurred.
Action: please refer to your system administrator

To avoid this, the "ICX: Limit time" profile was increased to 8 and "ICX:Session Timeout" profile to 180.

If someone goes through benefit enrollment and closes out their session by closing their browser instead of following the close applications in self-service, would it hold the database session open, thus keeping the record locked because of the timeout setting is so long?



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