Copying or adding a SKU level member in a worksheet sets an incorrect record type in the LV10MAST table with a Record_Type of 'L' (LIVE) instead of a Record_Type of ‘M’ (MODEL).

This problem only exist in SAS^® Merchandise Planning 6.1.3 M5 HF1 and later.

Circumventing this problem requires modifying the code in the BEF_UPD_LV10MAST trigger. The steps for modifying the code are listed on the Full Code tab of this note.

A fix for this issue is planned for a future software release.

Operating System and Release Information

Modify the following code in the BEF_UPD_LV10MAST trigger:

    ELSE
          :new.record_type := 'L';

For Oracle modify to:

ELSIF v_replace <> 1 THEN
         	 :new.record_type := 'L';


For UDB DB2 modify to:

ELSEIF v_replace <> 1 THEN
        SET new.record_type = 'L';