My Oracle Support Banner

Can Not Delete Data For A Custom Measure With DELETED_FLAG = Yes (Doc ID 2428056.1)

Last updated on JULY 26, 2018

Applies to:

Oracle Demand Management Cloud Service - Version 11.13.18.02.0 and later
Information in this document applies to any platform.

Symptoms

Using Planning Central / Load Planning Data from Flat Files
When attempting to delete data in a custom measure (non editable) originally loaded using FBDI template,

ACTUAL BEHAVIOR
---------------
MSC_ST_MEASURE_DATA.ERROR_TEXT=The value provided for the attribute DELETED_FLAG is invalid.
and
the Load Entity job ends in a Warning.

EXPECTED BEHAVIOR
-----------------
Expect the rows matching MSC_ST_MEASURE_DATA where DELETED_FLAG=1 would be deleted from the corresponding
base table and no warning would be generated claiming DELETED_FLAG=1 is an invalid value.

-- Steps To Reproduce:

Customer states the issue can be reproduced at will at customer site with the following steps:
1. Create a custom measure with lowest granularity
(Item Org, Customer Site, Demand Class, Sales Organization / granularity = 135)

2. Load data on this custom measure with FBDI template.

3. Data is uploaded successfully

4.Try to delete data for custom measure loaded in step # 2 by setting DELETED_FLAG = Yes.
4.a Use FBDI template in step # 2
4.b Change value of DELETED_FLAG from 'No' to 'Yes'. Save.
4.c Import FBDI template
4.d Run program to load custom measure data from FBDI template.
4.e Program errors with message - The value provided for the attribute DELETED_FLAG is invalid.

5. Inspect the corresponding rows in MSC_ST_MEASURE_DATA,
6. Observe the valid value of 1 for DELETED_FLAG
and the ERROR_TEXT=The value provided for the attribute DELETED_FLAG is invalid.

Cause

To view full details, 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 a vibrant support community of peers and Oracle experts.