Sort By Price in Product Listing Page throws ORA-00904 error
(Doc ID 2804420.1)
Last updated on DECEMBER 07, 2022
Applies to:
Oracle Commerce Cloud Service - Version 21.2.8 and laterInformation in this document applies to any platform.
Symptoms
On : NA version, Storefront
When attempting to sort products by price in PLP ,
the following error occurs.
ERROR
-----------------------
{"errorCode":"20040","message":"ORA-00904: \"PROD\".\"PRODUCT_ID\": invalid identifier\n","status":"500"}
STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Navigate to a PLP in the storefront.
2. Open up Network tab in browser dev tools
2. Click on the "View all products" button.
3. Select the "Price Low to High" sort option.
4. Observe that no product listings are displayed.
5. Observe failed network request
BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, Shoppers cannot sort products by price.
Changes
Catalog has been modified to a filtered Catalogs.
Cause
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
| Symptoms |
| Changes |
| Cause |
| Solution |
| References |