Last updated on DECEMBER 05, 2016
Applies to:Oracle Release Management - Version 18.104.22.168 to 22.214.171.124 [Release 11.5.10]
Information in this document applies to any platform.
***Checked for relevance on 18-Mar-2015***
***Checked for relevance on 05-Dec-2016***
On : 126.96.36.199 version, Demand Processor Related Issue
Customer recently implemented a project where they are using demand Processor to process EDI 866 transactions during this process customer identified that From monitoring Demand Processor sessions that long running times, have been identified along with expensive SQL coding in Process Order API for Firm days.
It seems apparent that the issue is with the hanging /locks on Order Header and Order Lines tables for the entire DSP runtime (i.e. Firm days fence + MRP Forecast days fence) and that it is contending with Order Management WSH Shipping and RLM Demand loading.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms