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.


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.

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.



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