SVP Aggregation Executes SQL Multiple Times for Account Not Selected

(Doc ID 2187792.1)

Last updated on MAY 29, 2018

Applies to:

Siebel CRM - Version 8.1.1.14.9 [IP2014] to 18.4 [Release V8 to V17]
Information in this document applies to any platform.

Symptoms



In Sales Volume Planning (SVP) for Consumer Goods, the SVP Build Tree job executes the same SQL multiple times, not limited to the selected Account.


The SQL executes multiple times for each of the SVP Categories:

 

Changes

 

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