My Oracle Support Banner

FAW Data Mismatch For DW_PURCHASE_ORDER_CF.AMOUNT_RECEIVED (Doc ID 2988883.1)

Last updated on NOVEMBER 29, 2023

Applies to:

Fusion Analytics Warehouse - Version 23.R3.x and later
Information in this document applies to any platform.

Symptoms

Created a simple report for Purchasae Order with following columns( Purchase order number, Purchase order line number, Distribution number,Ordered Amount, Total Amount,Delivered Amount and Received Amount)
and observed that DW_PURCHASE_ORDER_CF.AMOUNT_RECEIVED is not matching with the values in source system.

All columns in the above report is shown at distribution grain level then why Amount Received is shown at schedule level (value is doubled). User's want the Amount Received at Distribution level as it is causing issue to them while doing the analysis at aggregation level.

Changes

 

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


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