My Oracle Support Banner

How To Fetch Only The Products With SKUs (Doc ID 2902569.1)

Last updated on MARCH 21, 2024

Applies to:

Oracle Commerce Cloud Service - Version 22.3.4 and later
Information in this document applies to any platform.


Fetch all the products with SKUs, and avoid products that do not have any SKUs linked.

The below query is returning all the products including the ones without SKUs.

Can we add some more attributes to this query in order to avoid products without SKUs?


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

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