Does salesforce lock Account Record when user try to update/create following child objects -

    AccountTeamMember

    Opportunity Line Item (Does sfdc lock opportunity here as well?)

    Task

    Contact

    OpportunityTeamMember (Does sfdc lock opportunity here as well?)

Is this applicable to only Master Detail relationships ? (Not Lookups)

We are facing an issue in Accounts. Sometimes we are getting an error like 'Unable to lock row' while saving/updating data. Is it related to Account Data Skew issue? But in our org, no Account has more than 10000 child records.

What may be the possible cause and solution to this? Please suggest.

I Need to Store Number fields per used based on User role Hierarchy and need to do hierarchical Rollup later on once data is updated. Did anyone tried to do this in Salesforce.

One Approach I am thinking is store it on user record but not sure if there any way to auto rollup this data. Wanted to check what will be best data model for this.

 

Note: I am aware if forecasting in Salesforce, which is not going to work in this scenario.

 

Please find below is the sample data - 

 

• VP - 3000
• ----Mgr - 2000
• -----------Sales Rep - 1000
• -----------Sales Rep - 1000
• ------Mgr - 1000
• -----------Sales Rep - 1000

I Need to Store Number fields per used based on User role Hierarchy and need to do hierarchical Rollup later on once data is updated. Did anyone tried to do this in Salesforce.

One Approach I am thinking is store it on user record but not sure if there any way to auto rollup this data. Wanted to check what will be best data model for this.

 

Note: I am aware if forecasting in Salesforce, which is not going to work in this scenario.

 

Please find below is the sample data - 

 

• VP - 3000
• ----Mgr - 2000
• -----------Sales Rep - 1000
• -----------Sales Rep - 1000
• ------Mgr - 1000
• -----------Sales Rep - 1000