My Oracle Support Banner

No Records are Return when Performing a JOIN and a WHERE in BMQL (Doc ID 2552871.1)

Last updated on DECEMBER 15, 2019

Applies to:

Oracle BigMachines CPQ Cloud Service - Version 18 C to 19 C [Release 18 to 19]
Information in this document applies to any platform.

Symptoms

When performing a BMQL call to join two tables, and filtering based on an array set, no records are returned when the array is over 1000 values long.

An example BMQL query is as follows:

Changes

The INNER JOIN was recently added into the BMQL statement to join multiple tables.

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.