Symptom
After deleting a quote via scripting, it still shows under Load quotes page.
Environment
SAP SALES CLOUD CPQ
Reproducing the Issue
- Open CPQ
- Go to existing quote and look for quote number
- Use QuoteHelper.Delete('') script in your script workbench
- 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 |
SAP Knowledge Base Article - Public