We are getting this error whenever trying to update a record Location . It is saying without CMSLocationCode it cannot create child. But CMSLocationCode is already selected even after that it asking for its value. Not able to get why it is asking for CMSLocationCode even after giving it.
Please help on this.
For this a quick insight into how the records in DB behave will help.
When you update a relationship record with a new FK value, it will need to Delete existing rel record and create a new Rel record.
However, if the Delete strategy on the Provisioning tool if left to default DISASSOCIATE then it will simply blank the FK on the existing record which leads to this error.
So you need the strategy to be set to SOFT_DELETE instead.