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.
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,
MSC_ST_MEASURE_DATA.ERROR_TEXT=The value provided for the attribute DELETED_FLAG is invalid.
the Load Entity job ends in a Warning.
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.
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!