Is it possible to mark report as deleted as soon as submitted ? (Doc ID 2303891.1)

Last updated on JULY 13, 2023

Applies to:

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

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