You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

FBDI Load - Duplicate record is not allowed.

Received Response
2
Views
1
Comments

Summary: Load Entity rejects records if the measure data for item - organization - date combination is loaded with two records.ie. One records with deleted flag = yes and other one with deleted flag = no

Content (please ensure you mask any confidential information):

First time post plan run, we are loading data using ScpMeasureImportTemplate FBDI into a custom measure checked with "refresh with current data". We are loading the measure data with reference to the plan name in the FBDI. So data in msc_measures_data had plan_id = 300000XXXXXXXXXX.

Again (second time) when the plan is triggered in "refresh with current data" mode, we expected the data in the custom measure to be deleted as it was directly loaded into PDS database. But data loaded through FBDI was still available even though measure data and not was not deleted.

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!