AERS 4.6.1 COPY CASE DELETES ALL ROWS FROM QTEMP (Doc ID 969452.1)

Last updated on NOVEMBER 26, 2009

Applies to:

Adverse Event Reporting System - Version: 4.6.1 to 4.6.1 - Release: 4.6 to 4.6
Information in this document applies to any platform.

Symptoms

AERS 4.6.1

When you copy a case, the procedure DECOPYCASE deletes all rows in QTEMP regardless of the session ID.

The issue can be reproduced at will with the following steps:

  1. Log in as user 1 and run a query to retreive cases in Browse.
  2. Log in as user 2 and do the same.
  3. In SQL*Plus issue the command:
    select user_session_id, count(*) from qtemp;
  4. As user 2, copy one case.
  5. Re-run the SQL above, you will see only one row now remains in QTEMP.


Business Impact

User that run copy case seems to block new users from connecting (presumably because their query is trying to insert rows into qtemp). New user connections are blocked.



Cause

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