My Oracle Support Banner

Argus Insight: ETL Settings For ARGUS_APP.LIT_INTAKE (Doc ID 2708785.1)

Last updated on SEPTEMBER 24, 2020

Applies to:

Oracle Argus Insight - Version 8.2.1 and later
Information in this document applies to any platform.


After upgrading to Argus 8.2.1 ETL stopped working on certain tables for literature data in Japan.

Specifically, ARGUS_APP.LIT_INTAKE contains the record where  IMPORT_DATE >= 18-JUL-2020 (the date of the upgrade), but APR_MART.DM_LIT_INTAKE does not contain any records where IMPORT_DATE >= 18-JUL-2020.

The associated tables (APR_MART.DM_LIT_INTAKE_ASSESS, DM_LIT_INTAKE_FAMILY) also don't have the record created after Argus 8.2.1 upgrade.

Argus Insight 8.2.1 has a new configuration parameter:

Tools > List Maintenance > Profile Switches >POPULATE INTAKE TABLE DATA.

This is set to 0 by default. How does this new parameter affect the populating of the three DM_LIT_ tables?

Description of the configuration parameter from documentation 

0 = No Intake Tables data will be brought into the Datamart

1 = Intake Tables data will be brought into the Datamart


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.