Order Headers Stuck In Workflow As Deferred and Workflow Background Program (WFBG) Not Progressing After Upgrade Database to 10.2.0.4.0
Last updated on SEPTEMBER 20, 2017
Applies to:Oracle Database - Enterprise Edition - Version 220.127.116.11 to 10.2.0.4 [Release 9.2 to 10.2]
Oracle Order Management - Version 18.104.22.168 and later
Information in this document applies to any platform.
***Checked for relevance on 03-FEB-2017***
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.
Applied RDBMS patch set 10.2.0.4.0.
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