My Oracle Support Banner

View Regeneration Failing on Claims 3.21.2 Version (Doc ID 2815522.1)

Last updated on OCTOBER 20, 2021

Applies to:

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

Symptoms

On : 3.21.2.0.2 version, Installation

The view regeneration is failing on upgrade to Claims 3.21.2 version.


ERROR
-----------------------

nohup: ignoring input
2021-08-17 13:07:19.538 - [CONFIG] db url = jdbc:oracle:thin:@//devdb-scan:1531/xxx.xxx.org
2021-08-17 13:07:19.542 - [CONFIG] object owner = OHI_CLAIMS_OWNER
2021-08-17 13:07:19.542 - [CONFIG] views owner = OHI_CLAIMS_VIEWS_OWNER
Exception in thread "main" java.sql.SQLSyntaxErrorException: ORA-01031: insufficient privileges


The issue can be reproduced when running the jar file ohi-views-generator.jar

Cause

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
Symptoms
Cause
Solution


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