My Oracle Support Banner

Argus Safety Upgrade: ORA-02298: Cannot Validate (ARGUS_APP.FK_CSRP_REPORTER_TYPE) (Doc ID 2513507.1)

Last updated on JULY 13, 2023

Applies to:

Oracle Life Sciences Argus Safety - Version 8.1 and later
Information in this document applies to any platform.

Goal

Oracle Life Sciences Argus Safety Version 8.1

Upgrading Argus Safety 8.0.1 database to 8.1 (via patch Oracle Life Sciences Argus Safety 8.1.0.92 (Patch 24412728) and during this running into the following error:


On further investigation it appears as if there are two records in the CASE_REPORTERS table with values for the REPORTER_TYPE field that are not present in LM_REPORTER_TYPE.RPTR_TYPE_ID

What is recommendation to resolve and is this a known issue ?

Solution

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
Goal
Solution
References


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