Supplier Qualification - Qualifications and Assessments Real Time

Summary:

We are trying to create a report using "OTBI - Supplier Qualification - Qualifications and Assessments Real Time Subject Area" please find the report criteria and session log. Can you please help us to find why where clause has 1=2 condition added.

Content (please ensure you mask any confidential information):

Report criteria

Session query:

Session query:

WITH sawith0 AS (

SELECT /*+ inline */

t2396858.c14440248 AS c2,

t2396858.c404655606 AS c3,

t2396858.c340685110 AS c4,

t2396858.c31146014 AS c5,

t2396858.c365401738 AS c7,

t2396858.c413588529 AS c8,

t2396858.c291451658 AS c10,

t2396858.c520837264 AS c12

FROM

(

SELECT

v472595283.description AS c14440248,

v472595283.creation_date AS c404655606,