iStore cart does not expire even after quote_expiration_date is passed and not let user create cart
Hello,
We are on R12.1.3 with latest patchset. We have customization in ASO_QUOTE_CUHK which set the PRICE_FROZEN_DATE, PRICING_STATUS_INDICATOR when a new cart is created. here are some details.
Create_quote_POST - we set PRICE_FROZEN_DATE to a 10/21/2020 and PRICING_STATUS_INDICATOR = I.
UPdate_quote_POST - QUOTE_EXPIRATION_DATE is set to a 10/20/2020. System sets PRICING_STATUS_INDICATOR to C after cart is created.
Now, user has created a cart and it has quote_expiration as 10/20/2020. When user logs in on 10/21, they cant add items to cart or even create a new cart. We deleted the current active cart(940) in ibe_active_quotes_all as per