My Oracle Support Banner

Sort By Price in Product Listing Page throws ORA-00904 error (Doc ID 2804420.1)

Last updated on SEPTEMBER 09, 2021

Applies to:

Oracle Commerce Cloud Service - Version 21.2.8 and later
Information 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


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.