Follow-up Identification SQL

Oracle Argus Safety provides flexibility to change the logic for identification of Follow-up records. The identification of Follow-up records can be configured in the Follow-up Receive tab and is available for R3 based ICSR profiles that support the import.

The SQL mapping logic for the identification of Follow-up records is the Profile level logic to identify the Follow-up case against the incoming ICSR. For the OOTB, the default logic is the current Oracle Argus Safety embedded logic.

The following list details the bind variables that are available.

  • PI_INCOMING_RPT_ID
  • PI_CASE_RPT_ID
  • PI_USER_ID
  • PI_CASE_ID