My Oracle Support Banner

Order Total Not Calculating Correctly in Open Purchase Order BI Report (Doc ID 2231664.1)

Last updated on FEBRUARY 13, 2017

Applies to:

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


The order totals in the open purchase order is not calculated correctly. Orders are grouped by Not before date and location fields.

If the  order list for a specific grouping has more orders then it randomly takes the value  the 1st order  or last order in the corresponding list as order totals instead of calculating the sum of the all the orders in the list.

Steps to Reproduce:

  1. Login to the RMS and Navigate to Action. 
  2. Click on Reports. Select the module as "Orders" and select the report "Open Po Report".
  3. Click on OK , it will be redirected to Open Purchase order BI( Business Intelligence) report.
  4. Enter the Dept/Class/Subclass/Start Date/End Date information and execute the report.
  5. Verify the order totals are not calculated properly.





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

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