My Oracle Support Banner

Why Are Records Retained In ESM_RPT_STAGE For E2 R2 But Not E2 R3 Transmissions? (Doc ID 2652903.1)

Last updated on JULY 13, 2023

Applies to:

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

Goal


Records are deleted from table ESM_RPT_STAGE after R3 E2B import completes.

Ideally would like records permanently retained in table similar to records for R2 in child tables (DRUG,ACTIVESUBSTANCE ) for later querying.



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


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