Consumer Goods: Baseline Records Are Deleted For One Account

(Doc ID 1966261.1)

Last updated on SEPTEMBER 22, 2017

Applies to:

Siebel eConsumer Goods Sales - Version 8.1.1.10 [23021] and later
Information in this document applies to any platform.

Symptoms

For one Account, the baseline records are deleted during aggregation.


STEPS
1. The baseline was added for one Account: the corresponding baseline data was loaded successfully.
    In this step, the CG_SKIP_FLG is NULL.

2. The workflow was executed, calling the baseline aggregation.
    In this step, the CG_SKIP_FLG is set to D (in batches), resulting in all the records with the CG_SKIP_FLG = D being deleted.

Result: No baseline data is generated.

 

The following was captured in the logs:

UPDATE SIEBEL.S_PROD_BASELINE SET
    DB_LAST_UPD_SRC = :1,
    DB_LAST_UPD = sysdate,
    LAST_UPD = :2,
    LAST_UPD_BY = :3,
    MODIFICATION_NUM = :4,
    CG_BASE_CURCY_AMT = :5,
    CG_BASIS_CURCY_AMT = :6,
    CG_INCR_SALES = :7,
    CG_INCR_CURCY_AMT = :8,
    PLANNED_SALES = :9,
    CG_PLNG_CURCY_AMT = :10,
    X_DISP_OPN_STK_QTY = :11,
    X_OPEN_STOCK_REVENUE = :12,
    X_LE_CASES = :13,
    X_NEWPROD_CANNIB = :14,
    EQUIV_UNITS = :15
 WHERE
    ROW_ID = :16 AND MODIFICATION_NUM = :17

UPDATE  SIEBEL.S_PROD_BASELINE SET CG_SKIP_FLG = 'D' where CG_SKIP_FLG <> 'Y' AND ROW_ID = '1-N76LZT'

ObjMgrSqlLog Detail 4 0000000654af0e94:0 2015-01-09 12:11:52 INSERT/UPDATE statement with ID: Unknown

UPDATE  SIEBEL.S_PROD_BASELINE SET CG_SKIP_FLG = 'D' where CG_SKIP_FLG <> 'Y' AND ROW_ID = '1-N76M05'

ObjMgrSqlLog Detail 4 0000000654af0e94:0 2015-01-09 12:11:52 INSERT/UPDATE statement with ID: Unknown

SQLParseAndExecute Statement 4 0000000654af0e94:0 2015-01-09 12:11:52


BEGIN
UPDATE  SIEBEL.S_PROD_BASELINE SET CG_SKIP_FLG = 'D' where CG_SKIP_FLG <> 'Y' AND ROW_ID = '1-N76LZT';

UPDATE  SIEBEL.S_PROD_BASELINE SET CG_SKIP_FLG = 'D' where CG_SKIP_FLG <> 'Y' AND ROW_ID = '1-N76M05';

END;

 

Troubleshooting:


1. Confirm that baseline records are added in the leaf account level.  

   If they are not added in the leaf account, baseline records might be deleted during the build tree process since the aggregation process is performed from the bottom up.

 

 Note the Account hierarchy below:

                               Account A
                              /             \
                    Account B    Account C
                    /             \
           Account D   Account E
                 /    \
              …..    …..


In the above tree, Account C and E are leaf accounts.

2. In the TEST Environment, perform the SVP Adopt for each Product in the "bad" Account.
   a. Confirm the  Category – Product Hierarchies
       Navigate to Site Map > Administration - Catalog > Account Categories
       Query for the referenced Accounts: (check a "working" Account and compare against the "non-working" Account).
       Check the Categories that have been defined for the Account.
       Verify the Accounts and corresponding Categories.

   b. Perform SVP Adopt again for each Product in the 'bad" Account
        Navigate to Site Map > Administration - Catalog > SVP Categories > Visibility Filter: All Categories
        Drill down on the Category, Continue drilling down on the Subcategories until you reach the lowest level Subcategory that has Products listed.
        Confirm the associated Products that are listed in the lower applet correspond with the SVP Category.
        Select the Product, Click the "SVP Adopt" button.
        Continue the process until all Products have been re-SVP Adopted.

3.  For additional details on Categories-Products, please see the Siebel Consumer Goods Guide >  Sales Volume Planning >  Process of Setting Up Category-Product Hierarchies.

4.  After executing the SVP Adopt on each Product from the "bad" Account in the TEST environment, aggregate the baseline again.
 

5.  Copy the Authorized Distribution List (ADL) of a "working" Account over the ADL of the "non-working" Account.

 

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