This discussion is archived
6 Replies Latest reply: Oct 12, 2012 4:46 AM by Sarvesh_n RSS

Workflow Notification is getting deferred

Sarvesh_n Newbie
Currently Being Moderated
Hi All,

The PO Requisition Approval Notification Activity goes to 'Deferred' status instead of 'Notified' when the transition occurs and to make to 'Notified' i have to run the "Workflow Background Process" evrytime. The Same works fine in our Test Environment but does not work in our Development Instance. Both Instance is clone of Production. The "Workflow Background Process" is scheduled in both the instances.

I am unable to find out what is causing this, is it WF Engine Threshold setup or something? If so how to find the Threshold in both the instances. Please help to solve
issue.

Instance Details
OS: IBM AIX version6
EBS: 11.5.10.2
DB: 10.2.0.4.0

Thanks,
Sarvesh
  • 1. Re: Workflow Notification is getting deferred
    Srini Chavali-Oracle Oracle ACE Director
    Currently Being Moderated
    Pl identify the parameters used to run the Workflow Background Process in both instances, along with the schedule in both instances.

    Recommended Schedule For Workflow Background Process For Order Management [ID 971925.1]

    HTH
    Srini
  • 2. Re: Workflow Notification is getting deferred
    Sarvesh_n Newbie
    Currently Being Moderated
    Hi Srini,

    Thank you for your reply. The Background process schedule is same in both the instances. Please advice.


    Thanks,
    Sarvesh
  • 3. Re: Workflow Notification is getting deferred
    Srini Chavali-Oracle Oracle ACE Director
    Currently Being Moderated
    How about the parameters being passed for the background process in the two instances ?

    Srini
  • 4. Re: Workflow Notification is getting deferred
    Hussein Sawwan-Oracle Employee ACE
    Currently Being Moderated
    Sarvesh,
    The PO Requisition Approval Notification Activity goes to 'Deferred' status instead of 'Notified' when the transition occurs and to make to 'Notified' i have to run the "Workflow Background Process" evrytime. The Same works fine in our Test Environment but does not work in our Development Instance. Both Instance is clone of Production. The "Workflow Background Process" is scheduled in both the instances.

    I am unable to find out what is causing this, is it WF Engine Threshold setup or something? If so how to find the Threshold in both the instances. Please help to solve
    issue.
    Please see these docs.

    Workflow Background Process Does Not Progress Shipped Lines: Stuck in Fulfill - Deferred [ID 804133.1]
    How To Diagnose Purchase Order And Requisition Workflows in Deferred Status? [ID 884391.1]
    Why Is Requisition Approval Stuck In-Process / Deferred When Delegate Person Approves The Requisition? [ID 382935.1]
    PO Does Not Get Automatically Generated As Workflow Activity Goes Into DEFERRED Mode when Calling WF_STANDARD.noop. [ID 779805.1]
    11.5.10: How To Diagnose Intermittent Document Manager Error 3 During Purchase Order And Requisition Approval? [ID 1273090.1]

    Thanks,
    Hussein
  • 5. Re: Workflow Notification is getting deferred
    Hussein Sawwan-Oracle Employee ACE
    Currently Being Moderated
    Thank you for your reply. The Background process schedule is same in both the instances. Please advice.
    Can you find any errors in the Workflow/Database log files?

    Thanks,
    Hussein
  • 6. Re: Workflow Notification is getting deferred
    Sarvesh_n Newbie
    Currently Being Moderated
    Hi,


    Thanks to Hussein and Srini for your help. The Metalink Note "How To Diagnose Purchase Order And Requisition Workflows in Deferred Status? [ID 884391.1]" helped to identify the issue. The package “POXWPA7B.pls” version was different in our developement and test instances. This was because the patch 5508851 was applied in our test instance.

    select text
    from dba_source
    where line = 2
    and name = 'PO_WF_PO_NOTIFICATION';
    Development Instance: /* $Header: POXWPA7B.pls 115.38.11510.5 2005/03/22 10:15:55 nipagarw ship $ */
    Test Instance: /* $Header: POXWPA7B.pls 115.38.11510.10 2006/07/12 13:20:02 ambansal ship $ */

    After applying the same patch in development instance the deferreing of notification activity stopped occuring.

    Thanks,
    Sarvesh

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points