My Oracle Support Banner

Open PO Report Incorrect Calculation (Doc ID 2955788.1)

Last updated on JUNE 22, 2023

Applies to:

Oracle Retail Merchandising Foundation Cloud Service - Version 19.3 and later
Information in this document applies to any platform.


There appears to be an incorrect calculation on the Open PO Report from MFCS/BI Publisher. An example is PO 282211099. This PO was originally created for quantity 1270 units of item 2022024538. The supplier told us that they could not fit that many units on a container, so they order was adjusted to 1040 units on the order.

ORDLOC now reflects 1040 qty_ordered and 230 qty_cancelled, which is correct. In the Open PO report in BI Publisher however, the order now shows a qty_ordered of 1040, with an outstanding quantity of 810. The outstanding quantity and outstanding cost are incorrect on the PO report, because the math appears to be

qty_ordered - qty_cancelled. Qty 1040 is actually the outstanding quantity in this example.

Steps to Reproduce:

1. Find an Approved order with outstanding quantities and cancelled quantities.
2. In MFCS navigate to Report > Orders > Open Orders
3. In put criteria to search for PO.
4. The order outstanding quantity information on the Open PO report is incorrect.


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.