Is it possible to mark report as deleted as soon as submitted ?
(Doc ID 2303891.1)
Last updated on FEBRUARY 17, 2020
Applies to:Oracle Argus Safety - Version 7.0.6 and later
Information in this document applies to any platform.
Is it possible to mark as deleted a report immediately as submission is created?
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.
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