Mass Change in Consumer Goods Does not Update Records for Entered Dates

(Doc ID 2209370.1)

Last updated on SEPTEMBER 05, 2017

Applies to:

Siebel Consumer Goods - Version 15.7 [IP2015] and later
Information in this document applies to any platform.

Symptoms

On : 15.7 [IP2015] version, Consumer Goods

The Mass Change functionality allows user to update fields for a set of dates selected from the Mass Change applet.
However, when the user queries records for particular months in the base applet and then performs the Mass Change on different months, the field values do not update.

The Mass Change should execute the modifications on the selected field for the date range (Period Start and Period End) entered in the Baseline Mass Change
pop-up under Sales Volume Planning.

Instead, the Mass Change only modifies the specified field values that are displayed in the Product Baseline applet.

For example:
      In the Product Baseline applet, execute a Query where the Period=*2016*.
      The query displays the Product Baseline records for 2016.
      Click the Mass Change button, entering Period Start=2015 and Period End=2016.

     Result: The Mass Change modifies records that are currently displayed in the applet.
                Only the records for 2016 are changed (i.e., those records displayed in the Product Baseline applet).
                The requested Mass Change on records for 2015 are not changed.

STEPS
1. Launch Consumer Sector application using Sample database.
2. Navigate to Sales Volume Planning.
3. Select Account: ABC Mart US
    a. Drill down to lowest level Category: Ace Beverage > Water > Cool > Cool Water 12 oz.
    b. Confirm records are displayed in the Product Baseline applet.
    c. Check Record Count for Product Baseline:
        ==> Result: There are 260 records in your query for Product Baseline.

    d. Check value for Baseline Qty since this will be modified: Baseline Qty=218,902

4. Click on the Mass Change button in Product Baseline applet.
   [Note: No query has been executed on the base Product Baseline applet: all 260 corresponding records are displayed in the applet.]

5. Enter values in the Baseline Mass Change pop-up:
     Algorithm Type: Flat Change
     Field: Baseline Qty
     Value: 100
     Period Start: Week 1, 2001
     Period End: Week 52, 2001

6. Click Execute (button) on Baseline Mass Change pop-up.

    Result: This correctly updates the Baseline Qty field values to 100 on all records for Week 1 - Week 52, 2001 since those records were displayed in the Product Baseline applet.

 

7. Execute a query in the Product Baseline applet for Period=*2002*.
    52 records are available for 2002 (one record for each week for Year 2002).

8. Click the Mass Change button in Product Baseline applet.
   [Since a Query has been executed for Period=*2002*, only Product Baseline records for 2002 are currently displayed in applet.]

9. Enter values in the Baseline Mass Change pop-up:
    Algorithm Type: Flat Change
    Field: Baseline Qty
    Value: 225
    Period Start: Week 1, 2001
    Period End: Week 52, 2002

10. Click Execute (button) on Baseline Mass Change pop-up.

11. Query in Period field for all records where Period = *2001* OR *2002*

     Result: Baseline Qty field was updated with values to 225 only for records in 2002 since those records were displayed in base applet.

   Only the record set displayed in the query for Year 2002 were changed.
   The Baseline Qty field value for the Period between Period Start for Week 1, 2001 and Period End for Week 52, 2001 were not modified since they were not displayed in the applet.

   The Baseline Qty field for Year 2001 still displays the previous value of 100.




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