My Oracle Support Banner

User Don't See Data Extracted in Custom Case Line Listing in Argus Insight (Doc ID 2946333.1)

Last updated on JULY 13, 2023

Applies to:

Oracle Life Sciences Argus Insight Cloud Service - Version 8.2.2 and later
Oracle Life Sciences Argus Insight - Version 8.2.2 and later
Information in this document applies to any platform.

Symptoms

User observed that for a case, record exists in the CASE_MASTER of ARGUS SAFETY schema.

SELECT CASE_NUM, CASE_ID FROM CASE_MASTER WHERE CASE_NUM IN ('XXXXXXXX');

  

For the given case there is an entry in the CASE_PRODUCT table  as well :

SELECT * FROM CASE_PRODUCT WHERE CASE_ID IN (SELECT CASE_ID FROM CASE_MASTER WHERE CASE_NUM IN ('XXXXXXXX') );

 

An argus_insight ETL is executed daily to populate the tables in APR_APP and APR_MART.

However, in the RPT_PRODUCT table of the APR_APP/APR_MART schema, user don’t see the product getting populated.

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.