"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:

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

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.