Set up a new Oracle Argus Mart 8.2 Integration for use with Oracle Empirica Signal

If you are integrating Oracle Argus Mart 8.2 or later for use with Oracle Empirica Signal for the first time (no existing integration), perform these steps using the non-privileged user account on the application server.

Note: If a previous version of Oracle Argus Mart is already integrated with Oracle Empirica Signal, follow the procedure found at Update an Existing Oracle Argus Mart 8.x Integration.

1. Copy the Update_AM_for_Signal_9_2_x_x_xxx.zip file from the distribution media to a temporary directory on the server.
2. Unpack the Update_AM_for_Signal_9_2_x_x_xxx.zip file into a temporary directory, for example:

   $ unzip Update_AM_for_Signal_9_2_x_x_xxx.zip -d /u01/stage/

   The /UPDATE_AM_FOR_SIGNAL subdirectory is created.

3. Navigate to the /UPDATE_AM_FOR_SIGNAL directory, for example:

   $ cd /u01/stage/UPDATE_AM_FOR_SIGNAL

4. Using a text editor, open the create_argus_spontaneous_configurations.sql file.
5. Locate the following WHERE clause:

   WHERE UPPER (report_type_ve) IN (''SPONTANEOUS'',''LITERATURE'')

   The WHERE clause describes the spontaneous reports from the Oracle Argus Mart database user account.

6. Modify the WHERE clause as needed.
7. Save and close the file.
8. Execute the UPDATE_AM_8_0_FOR_SIGNAL_8_1.sql script as the am_mart_user, for example:
   $ sqlplus am_mart_user@<TNS_name> @UPDATE_AM_8_0_FOR_SIGNAL_8_1.sql

   A password prompt appears.

9. Enter the am_mart_user database account password, and then press Enter.

Note:

If you customized your Argus data, inspect and update your database restrictions for signal management, if necessary.