My Oracle Support Banner

Purchase Order Only Queries Using Transfer Or Shipment Tables (Doc ID 2979721.1)

Last updated on OCTOBER 11, 2023

Applies to:

Oracle Retail Insights Cloud Service Suite - Version 23.2 and later
Information in this document applies to any platform.

Symptoms

On : 23.1 , OBIEE - Reports/Dashboard

ACTUAL BEHAVIOR
---------------
PROD CFS » Purchase Order only queries using Transfer or Shipment tables

When a visualization is created in DV with Purchase Order data, the results are not correct.
Validating the generated query, we noticed that it is trying to also pull data from Transfer or Shipment tables - which weren't present in the visualization.

STEPS
-----------------------
The issue can be reproduced at will with the following steps:

1. Create a visualization bringing PO data for items of a specific department
2. Notice that is does not bring the correct details.


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
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.