CPQ Spring ‘19 – Delete SBQQ__Opportunity__c from the Quote Object.

When version 26 of Salesforce CPQ + Billing was introduced in September 2016, the SBQQ_Opportunity_c field was replaced by SBQQ__Opportunity2__c. This field allows you to maintain the relationship between Quotes and Opportunities, and the introduction of SBQQ_Opportunity2_c allowed users to create quotes without first requiring to have an Opportunity record in place. 

Both SBQQ__Opportunity__c and SBQQ__Opportunity2__c should share the same values, so we recommend that you verify that all triggers and customizations reference the new lookup SBQQ__Opportunity2__c field. Any roll-up summaries on the Opportunity object will also need to be removed or redesigned. 

Once you verify that SBQQ__Opportunity__c is not being referenced, you should delete that field and upgrade to Salesforce CPQ Spring ’19 v218.x. 

If you fail to remove the field and attempt to upgrade, you’ll receive the error message: “common.exception.SfdcSqlException: ORA-20127: maximum depth of master-detail relationship exceeded.”


Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.