How To Purge E-Mail workflow notifications From the EBS workflow queue.

How To Purge E-Mail workflow notifications From the EBS workflow queue. | Sometimes we need to purge the huge workflow notifications queue in EBS workflow, because of mailer services got failed and giving an error while starting or while refreshing/cloning new instance. 

How To Purge E-Mail workflow notifications?

As we know that old e-mail workflow notifications not needed in cloned instance. In this scenario we have to purge all those workflow notification queue from cloned ebs instance.

Before purge e-mail workflow notifications, using below script to verify the current status in table WF_NOTIFICATIONS that has to be sent when mailer services get started.

SQL> select notification_id, begin_date, recipient_role, message_type, message_name, status, mail_status from wf_notifications Where Status In ('OPEN', 'CANCELED') And Mail_Status In ('MAIL', 'INVALID') --and begin_date < sysdate-30  --> List only emails older than 30 days ago order by notification_id;

Output: –

NOTIFICATION_ID BEGIN_DATE RECIPIENT_ROLE MESSAGE_TYPE

MESSAGE_NAME STATUS MAIL_STATUS

6273813 4/26/2016 4:01:17 PM SYSADMIN OMERROR OMERROR_MSG 

OPEN MAIL

6273814 4/26/2016 4:01:18 PM SYSADMIN OMERROR OMERROR_MSG 

OPEN MAIL

6273815 4/26/2016 4:01:18 PM SYSADMIN OMERROR OMERROR_MSG 

OPEN MAIL

6273816 4/26/2016 4:01:19 PM SYSADMIN OMERROR OMERROR_MSG 

OPEN MAIL

✍Update the mail_status to send, if you have not requirement for old workflow email notification. It will not en-queue the messages again.

SQL>update WF_NOTIFICATIONS set mail_status = 'SENT' where mail_status in ('MAIL','INVALID') and Status In ('OPEN', 'CANCELED');

To hide Workflow ‘Work List Bell Icon’, you may check below to do so.

https://readmeout.com/how-to-hide-workflow-work-list-bell-icon-in-r12-2-5-to-r12-2-8-release-12-2/

Purge the WF_NOTIFICATION_OUT queue and rebuild it with data currently in the WF_NOTIFICATIONS table.

SQL> @$FND_TOP/patch/115/sql/wfntfqup.sql apps apps applsys

PL/SQL procedure successfully completed.

Elapsed: 00:00:01.01

Commit complete.

Elapsed: 00:00:00.00

**** TEMPORARY TABLES / AQs created ****

PL/SQL procedure successfully completed.

Elapsed: 00:00:01.43

**** Messages backed up ****

Commit complete.

Elapsed: 00:00:00.00

**** wfaqback.sql completed,  executing SQLs from wfntfqup

PL/SQL procedure successfully completed.

Elapsed: 00:00:17.37

***  invoking wfaqrenq.sql ******

*** Re-enqueing messages

PL/SQL procedure successfully completed.

Elapsed: 00:00:00.26
Commit complete.

Elapsed: 00:00:00.00

***** Objects related to wf_queue_temp_evt_table and 

wf_queue_temp_jms_table are dropped *****

***** Re-enqueue OF Alerts completed *****

Disconnected from Oracle Database 11g Enterprise Edition Release 

11.2.0.4.0 - 64 bit Production With the Partitioning, OLAP, Data Mining and Real Application Testing options

[applmgr@prdsrv scripts]$

After that need to be start the workflow mailer services.

Must Read: –

6 thoughts on “How To Purge E-Mail workflow notifications From the EBS workflow queue.”

  1. If you have Herpes in your whole body such as fever blisters, hsv, or roofing shingles you know what it is like to stay with the pain and discomfort that herpes delivers. I don't need to tell you how awesome it would be to find something that works so well that you no longer need to fear about stress or outbreak,Dr Itua herbal medicine cure my herpes in two weeks of taking it.is genuine and natural herbal medicine it has no side effect, The reason I'm writing this is that I promised Dr Itua I will share his herbal work to the world to see Herpes is no more a big deal.also Dr Itua can as well cure the following diseases…HIV,Hsv 1/2,Hepatitis B,Cancer, Diabetes, Men/Woman Infertility, Scoliosis,Fibromyalgia,Fluoroquinolone Toxicity
    Syndrome Fibrodysplasia Ossificans Progressiva.Fatal Familial Insomnia Facator V Leiden Mutation , Lottery Spell,Copd, Shingles,Fibroid, Fibromyalgia, Liver/Kidney Inflamotry, Epilepsy,Hpv,Weak Erection,Wart Remover,Cold Sore, Coeliac disease,Creutzfeldt–Jakob disease,Cerebral Amyloid Angiopathy, Ataxia,Arthritis,Amyotrophic Lateral Sclerosis,Alzheimer's disease,Adrenocortical carcinoma.Asthma,Allergic Asthma. Here His Contact…[email protected]/Whatsapp Phone.+2348149277976. I paid for his herbal medicine and sent it to me through Courier Service which I pick it urgently and used.

    Reply
  2. Have you ever considered about adding a little bit more than just your articles? I mean, what you say is fundamental and all. But imagine if you added some great pictures or video clips to give your posts more, "pop"! Your content is excellent but with images and videos, this blog could undeniably be one of the greatest in its field. Very good blog!
    Expediente Electrónico

    Reply
  3. Hey Gina! I saw your comment about Dr. Uduehi’s medication concerning Fibroid sometime ago and you were right, I tried it and it worked like magic for me. It was like hell living with FIBROID all this years until now, no more pains, bleeding and no miscarriage and I would've come with my testimony before now but I have to wait for a couple of months to see if it will regrow again but there's still no sign of fibroid, I also went to the hospital for test and still i was tested negative. All thanks to Dr. Uduehi and to you too Gina. And for anyone out there who wish to try can reach the doctor through: (+2347084878384) [email protected]

    Reply
  4. MY DAUGHTER CANCER HEALING TESTIMONEY

    Hi everyone, this is good news, a perfect and greats one. My daughter of
    17years who has suffered of Ovarian Cancer for 2 and half years has been
    cure by a Herbal doctor called Dr voodoo, who uses herbal and traditional
    medicine to cure people. I have spent so much on my daughter's health for
    years but no improvement. A friend told me about this herbal man who cure
    people with herbal medicine. he cures all sickness, diseases, viruses, and
    infections with his different herbal curing medicine.The result that
    declares my daughter janet healed was from a hospital here in USA, And the
    results of the test says my daughter was okay. Dr voodoo directed that
    janet would be heal in 7days if she uses the medicine as directed. And
    7days later, we went to confirm from the central hospital and several test
    that was done says my daughter is not sick or anything. So she was cured by
    this herbal doctor in 7days. This amaze me though. I would advice everyone
    to meet this Dr voodoo his email is [email protected]
    for his herbal medicine to cure your illness because am happy to see my
    daughter healthy again.Meet Dr voodoo and set yourself and your love ones
    will free you can also add Dr voodoo on whatsApp +2348140120719

    Reply
  5. I was married at 32 and immediately tried to get pregnant. When I was unable to conceive I had blood tests for fertility and was told that I had an FSH (follicle stimulating hormone) of 54 and would not be able to have children. Even though the doctors knew that I had been diagnosed with Hashimoto’s thyroiditis since age 25, no one bothered to check my thyroid levels. my TSH was measured at .001. My Synthroid dosage was lowered. a friend advise me to contact a spiritualist who help with fertility with his medicine, i collected his contact and explain my situation to him he prepared for me a herbal medicine which i took as describe by him. became pregnant very quickly, I had a successful pregnancy. I have my baby august 2017. to get pregnant at age 35 with my 2nd child in september 2019, thank you sir , this is his email contact if you require his help [email protected] or Facebook at priest.babaka

    Reply
  6. DO YOU NEED A PERSONAL/BUSINESS/INVESTMENT LOAN? CONTACT US TODAY VIA WhatsApp +19292227023 Email [email protected]

    HELLO
    Loan Offer Alert For Everyone! Are you financially down and you need an urgent credit/financial assistance? Or are you in need of a loan to start-up/increase your business or buy your dream house. GET YOUR INSTANT LOAN APPROVAL 100% GUARANTEED TODAY NO MATTER YOUR CREDIT SCORE. WhatsApp:+19292227023 Email: [email protected]

    Reply

Leave a Comment