SVP Aggregation Executes SQL Multiple Times for Account Not Selected

(Doc ID 2187792.1)

Last updated on SEPTEMBER 22, 2017

Applies to:

Siebel CRM - Version 8.1.1.14.9 [IP2014] and later
Information in this document applies to any platform.

Symptoms

On :  8.1.1.14.9 [IP2014] version, Client Functionality

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:

 



STEPS
1. Launch Consumer Sector application ( econsumersector_enu ).

2. Navigate to Site Map > Administration - Sales Volume Planning > SVP Actions > Aggregate tab.

3. Create a new record with the following:
    Action: Aggregate
    Description: Aggregation for Account X
    Source Table: Baseline
    Start Period: Week 01, 2016
    End Period: Week 03, 2016
    Account: Account X

4. Click "Execute Action" button.

5. Query in SVP applet for SVP Action: watch for status to go from Pending to Complete.

6. Review Workflow Object Manager to observe SQL was not specific to Account X.



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