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