Is it possible to mark report as deleted as soon as submitted ?
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.
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.
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