My Oracle Support Banner

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

To view full details, sign in with your My Oracle Support account.

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


In this Document
Goal
Solution


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.