My Oracle Support Banner

"No Results" When Pulling Columns From "Product Management - Source System Item Real Time"."Item Attachments" (Doc ID 2810145.1)

Last updated on OCTOBER 11, 2021

Applies to:

Oracle Fusion Product Hub Cloud Service - Version 11.13.21.04.0 and later
Information in this document applies to any platform.

Symptoms

When adding ANY Column from "Product Management - Source System Item Real Time"."Item Attachments", the analysis returns "No Results".
When removing the column from "Product Management - Source System Item Real Time"."Item Attachments", the analysis runs fine.

Example, the following Analysis runs fine:

SET VARIABLE PREFERRED_CURRENCY='User Preferred Currency 1',DISABLE_CACHE_HIT=1,DISABLE_PLAN_CACHE_HIT=1,LOGLEVEL=7,PREFERRED_CURRENCY='User Preferred Currency 1',QUERY_SRC_CD='Report';SELECT
  0 s_0,
  "Product Management - Source System Item Real Time"."Main"."Item Description" s_1,
  "Product Management - Source System Item Real Time"."Main"."Item" s_2,
  "Product Management - Source System Item Real Time"."Main"."Organization Code" s_3,
  0 s_4,
  DESCRIPTOR_IDOF("Product Management - Source System Item Real Time"."Main"."Item") s_5
FROM "Product Management - Source System Item Real Time"



Although, when adding any columns from the "Item Attachments" dimension, the analysis returns "No Results"
eg:

SET VARIABLE QUERY_SRC_CD='Report',PREFERRED_CURRENCY='User Preferred Currency 1',DISABLE_CACHE_HIT=1,DISABLE_PLAN_CACHE_HIT=1,LOGLEVEL=7;SELECT
  0 s_0,
  "Product Management - Source System Item Real Time"."Item Attachments"."File Name" s_1,
  "Product Management - Source System Item Real Time"."Main"."Item Description" s_2,
  "Product Management - Source System Item Real Time"."Main"."Item" s_3,
  "Product Management - Source System Item Real Time"."Main"."Organization Code" s_4,
  DESCRIPTOR_IDOF("Product Management - Source System Item Real Time"."Main"."Item") s_5
FROM "Product Management - Source System Item Real Time"

Changes

Add any column from the "Item Attachments" dimension to the analysis.

 

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.