I got a request to add a user to a distribution list for a scheduled BI Publisher job which runs every day at 9:00 am. When I went looking for the job in Report Job section it wasn’t there. However when I went to Report History section I could see the jobs were running successfully.
After talking to Oracle it seems that its a bug in BI Publisher. If a report job was created by User A and then deleted by User B it gets deleted from the UI but the underlying tables still have the information.
Oracle provided a solution to resolve this issue
1. Find the Parent Job ID
2. Purge the hobs in the following order from the Quartz tables.
You should be good to go. !!