Is it possible to mark report as deleted as soon as submitted ?

(Doc ID 2303891.1)

Last updated on SEPTEMBER 25, 2017

Applies to:

Oracle Argus Safety - Version 7.0.6 and later
Information in this document applies to any platform.

Goal

Question:

 

Is it possible to mark as deleted a report immediately as submission is created?

For example:

Received a requirement from client that they want to ignore a small subset of submission records for submission to authorities - hence these records need to be soft deleted from the system.


For example, if a new submission record is created and if it satisfied set of condition like (agency_id = 123456 , license_id = 101101) then this submission record should be deleted as soon as it is created.


To achieve that we have created a Before Insert Trigger on CMN_REG_REPORT table and after checking all set of conditions we mark this record as soft deleted. But we are not able to hard delete the CMN_REG_REPORT_BBF table record.

Due to which this record appears in bulk reporting screen.


 

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