Deleting selected records in a report

Problem

You want the user to be able to delete certain records in a report.

Solution

Add an item Px_DELETE_ID - where x is the page number

Create a page process, specify process conditions that Request = DELETE

delete from table where id = :Px_DELETE_ID; 
:Px_DELETE_ID := NULL;

Update the report to have an id column. Something like: id delete_id

Update delete_id column attributes to specify link - Specify URL target as javascript, to something similar to:

javascript:apex.confirm('Are you sure you want to delete this item?', {request : 'DELETE', set : {'P1_DELETE_ID': #DELETE_ID#}})




Result




Acknowledgement

https://community.oracle.com/message/9390078