OTBI Dashboard Prompt based on "Trading Partner Item Details" is not returning values — Cloud Customer Connect
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register
Get Started with Redwood: Oracle Cloud SCM and Purchasing

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

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!