Batch Reclassify: It Doesn't Work With "Only Update Fields Affected By Dictionary Changes? = Y" (Doc ID 2081091.1)

Last updated on MARCH 10, 2016

Applies to:

Adverse Event Reporting System - Version 4.7 and later
Information in this document applies to any platform.

Goal

Oracle Adverse Event Reporting System Version 4.7

There are issues with the Batch Reclassify functionality, it appears to work incorrectly if users run the report (with any case id) and 

the runtime option "Only update fields affected by dictionary changes? = Y"


e.g.

- Reports
- Data Management
- Batch Reclassify
- If we set the flag to Y, we also get:

Terminated with error:
REP-1401: 'beforereport': Fatal PL/SQL error occurred.
ORA-00904: "S"."DEF_INSTANCE_NAME": invalid identifier
ORA-06512: at "AERS1.AERS_DICTIONARY_API", line 2008



Running the report with "Only update fields affected by dictionary changes? = N", it works correctly.

How to resolve ?

Also request to provide the differences between the 2 different ways? What happens if run the report with "Only update fields affected by dictionary changes? = N" ? Which are the fields updated?
 

Solution

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms