How the OM workflow data is populated in Wf_notifications Table ?

(Doc ID 1399994.1)

Last updated on JANUARY 09, 2018

Applies to:

Oracle Order Management - Version 11.5.10.2 and later
Information in this document applies to any platform.
***Checked for relevance on 21-Aug-2013***

Goal


We have following queries on wf_notifications table
1) When the status in wf_notifications table of a particular data gets "CLOSED" from "OPEN"
2) Can we purge the data with "OPEN" status ?
3) How to purge the data from Wf_notifications Table ?
4) How to change the receipient_role from sysadmin to the correct user ?


Solution

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