My Oracle Support Banner

BIP - Open Orders Report Is Not Grouping Correctly Data Neither Showing Subtotals Correctly (Doc ID 2881208.1)

Last updated on JULY 06, 2022

Applies to:

Oracle Retail Merchandising System - Version 16.0.3 and later
Information in this document applies to any platform.

Symptoms

On : 16.0.3 version, Other

ACTUAL BEHAVIOR
---------------
Order Totals cost and retail showing only the first PO cost and retail in OPO BI report instead of sum of all the PO in the same group

EXPECTED BEHAVIOR
-----------------------
Order Totals cost and retail should show the sum of all the PO in same group.

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Create multiple purchase order with same item, not after date, location and supplier.
2. Extract the OPO report from BI Publisher
3. Noticed the Order Totals is only first PO cost instead of sum of all the PO in the same group.

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.