Order Headers Stuck In Workflow As Deferred and Workflow Background Program (WFBG) Not Progressing After Upgrade Database to 10.2.0.4.0 (Doc ID 1098518.1)

Last updated on SEPTEMBER 20, 2017

Applies to:

Oracle Database - Enterprise Edition - Version 9.2.0.1 to 10.2.0.4 [Release 9.2 to 10.2]
Oracle Order Management - Version 11.5.10.2 and later
Information in this document applies to any platform.
***Checked for relevance on 03-FEB-2017***

Symptoms

Order headers are not closing even though the lines are all closed.

The database was upgraded to 10.2.0.4.0  with no immediate indication of any problems with the workflow. 
There is custom workflow on the order header 'Order Flow - Generic' but it has been in place for years without this issue.



STEPS TO REPROUCE

1. Order Management Responsibility
2. Sales Orders > Enter order
3. Enter lines
4. Pick, Ship, Fulfill and close all lines
5. Header is stuck and does not close as expected.

Changes

Applied RDBMS patch set 10.2.0.4.0.

Cause

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