My Oracle Support Banner

OHI Upgrade Failed Error: ORA-04021: timeout occurred while waiting to lock object (Doc ID 2210345.1)

Last updated on OCTOBER 10, 2019

Applies to:

Oracle Health Insurance Claims Adjudication - Version and later
Information in this document applies to any platform.
***Reviewed for relevance on 5-May-2018***


When upgrading to OHI Claims 2.16.1 an error occurred:

SEVERE 11/16/16 6:01 PM:liquibase: Error executing SQL create or replace package cla_data_purge_pkg
  Purges tables:
  o enrollments and their details
  o payment status and their details
  o callout executions and details

  p_purge_days : the amount of days to purge data in the past
 procedure purge_data
 ( p_purge_days in integer

end cla_data_purge_pkg;
java.sql.SQLException: ORA-04021: timeout occurred while waiting to lock object


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

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