SAP Knowledge Base Article - Public

3407533 - Quote is available even after deletion

Symptom

After deleting a quote via scripting, it still shows under Load quotes page.

Environment

SAP SALES CLOUD CPQ

Reproducing the Issue

  1. Open CPQ 
  2. Go to existing quote and look for quote number
  3. Use QuoteHelper.Delete('') script in your script workbench
  4. After that quote disappeared from UI, but it still exists in tables. You can check by following script:
    sor_num = '<quote number>'
    sqlQuery = SqlHelper.GetFirst("select count(*) as cnt from Cart2 where '<CartCompositeNumber>'='" + '<sor_num>' + "'")
    if sqlQuery.cnt > 0:
        Trace.Write("Order exists")

Cause

It takes around 24 hours to reflect correctly on the quote table, in case the quotes were deleted via scripting.

Resolution

You can see the expected result after 24 hours of deletion.

"Image/data in this KBA is from SAP internal systems, sample data, or demo systems. Any resemblance to real data is purely coincidental."

Keywords

quote, delete, deletion, load quotes page, scripting, quote table , KBA , CEC-SAL-CPQ , Sales Cloud CPQ , Problem

Product

SAP CPQ 2020

Attachments

Pasted image.png