Mismatch in number of records exported from custom object created from Customer BO and the data displayed in Customer OWL(UI).
Reproducing the Issue
- Go to workcenter Data workbench
- Go to Export View
- Select your custom object
- Export all data
You notice that the number of records exported from Data workbench and that from the Customer OWL are different.
The data from the custom object would contain all the root level data including Customer, Individual Customer and also marketing leads as explained below.
The difference between the standard service ie. Customer and the custom object created from Customer BO is due to the "MarketingLeadIndicator" in ROOT node of BO "Customer".
The export from the custom object also contains marketing leads. Each time you create a lead there is a customer created in background with LifeCycleStatusCode = In Preparation and MarketingLeadIndicator = X.
Note that the "marketing-lead-customer" is never shown in the Customer OWL or in the Odata service : Customer but internally filtered out. This account will appear in the OWL and in the Odata service if the lead gets converted.
Thus you might have to add a new filter criteria MarketingLeadIndicator <> X and LifeCycleStatusCode <> In Preparation to get the same results.
Also, the custom object would contain Individual Customer records.
Customer, Data workbench , Export, MarketingLeadIndicator , KBA , LOD-CRM-ACC , Account , Problem