OTBI Dashboard Prompt based on "Trading Partner Item Details" is not returning values

Summary:

We have. a dashboard that contains an analysis and a prompt.

The prompt is based on the following sql query:

SELECT
   0 s_0,
   "Product Management - Trading Partner Item Real Time"."Trading Partner Item Details"."TP Item Number" s_1
FROM "Product Management - Trading Partner Item Real Time"

When trying to select from the prompt, I get no rows. The same column pulls data fine when used inside an analysis

We looked at the nqquery log attached here and we could see this sql query:

WITH SAWITH0

AS (

SELECT T288232.C132658618 AS c1

FROM (

SELECT V228609011.TP_ITEM_NUMBER AS C132658618