2.15.1.0.0 Upgrade Fails with Error ORA-20000: Failed Jobs Detected, Check Trace Files for Details

(Doc ID 2114790.1)

Last updated on OCTOBER 16, 2016

Applies to:

Oracle Health Insurance Claims Adjudication - Version 2.15.1 and later
Information in this document applies to any platform.

Symptoms

On Test: 2.15.1.0.0 version, Installation

When attempting to apply patch 21224090 (ORACLE HEALTH INSURANCE CLAIMS ADJUDICATION RELEASE 2.15.1.0.0),
errors occur while running the upgrade script.

ERROR
-----------------------
ORA-20000: Failed jobs detected, check trace files for details
ORA-06512: at "OHI_CLAIMS_OWNER.OHI_PARALLEL_JOBS_PKG", line 110
ORA-06512: at line 130

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1.
Follow steps from the readme file to apply patch 21224090 (release 2.15.1.0.0).
2.
When the upgrade script is run, errors show in the logging.



Cause

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