Tune Application Module - Release Mgmt Demand Processor (Doc ID 1373848.1)

Last updated on DECEMBER 05, 2016

Applies to:

Oracle Release Management - Version 11.5.10.2 to 11.5.10.2 [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***

Symptoms

 On :  11.5.10.2 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.

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