Project and Portfolio Management Practitioners Forum
cancel

Deleting Notifications

SOLVED
Go to solution
Highlighted
lmunoz
Contributor.

Deleting Notifications

Hello,

I've created some notifications inside a PPM workflow and done some test before configuring my SMTP connection. I want to configure it now, but I need to delete all my test notifications generated before doing it, my "outbox". Which tables do I have to truncate? There are several tables notification related with:

 

KNTA_NOTIF_INTERVALS_LOC

KNTA_NOTIF_INTERVALS_NLS

KNTA_NOTIF_TXN_COLUMNS

KNTA_NOTIF_TXN_DETAILS

KNTA_NOTIF_TXN_PARENTS

KNTA_NOTIF_TXN_RECIPIENTS

KNTA_NOTIF_TYPE_MESSAGES

KNTA_NOTIFICATION_COLUMNS

KNTA_NOTIFICATION_RECIPIENTS

KNTA_NOTIFICATION_TYPES

KNTA_NOTIFICATIONS_LOC

KNTA_NOTIFICATIONS_NLS

KNTA_NOTIFICATIONS_TEMP

 

Thanks

2 REPLIES
Celil
Acclaimed Contributor.
Solution

Re: Deleting Notifications

Hi,

 

Please try to truncate knta_notif_txn_parents table.

 

Celil

 

Celil

IT Governance Professional
& PPM Solution Architect
lmunoz
Contributor.

Re: Deleting Notifications

Thanks