My Oracle Support Banner

In Oracle iSupplier Portal, After Upgrade From Older R12.2.x Version to R12.2.9 or R12.2.10, Values for Amount Ordered and Amount Received Are Zero or Missing (Doc ID 2772494.1)

Last updated on MAY 20, 2022

Applies to:

Oracle iSupplier Portal - Version 12.2.9 to 12.2.10 [Release 12.2]
Oracle iProcurement - Version 12.2.9 to 12.2.10 [Release 12.2]
Information in this document applies to any platform.


In Oracle iSupplier Portal, Release 12.2.9 and 12.2.10, the Amt Ordered and Amt Received column values are showing "0" (zero) and are null (missing), respectively, when viewing the shipments for a PO line.

It is expected that the correct values will be displayed in the Amt Ordered and Amt Received columns for the shipments.
Due to this issue, users cannot see the correct amount ordered or amount received values. This adds to confusion and uncertainty about the data during the procurement process.

Previously the environment was on R12.2.4, and in R12.2.4 the same PO shipments are showing the correct values. So the issue is noticed to occur after the upgrade to Release 12.2.9 or 12.2.10.

Steps To Reproduce

The issue can be reproduced at will with the following steps in a Vision Demo environment.

NOTE: In the information below, any user details / company name / address / email / telephone number / other data represent a fictitious sample (based upon made-up data used in the Oracle Vision Demo environment). Any similarity to actual persons, living or dead, is purely coincidental and not intended in any manner.


1. Navigate to iSupplier Portal Internal View responsibility > iSupplier Home Page.
2. On the iSupplier Portal Home Page, click the Orders tab.
3. Search for PO 6539 and Supplier = Advantage Corp
4. In the search results, click the "6539" link
5. On the View Order Details page for standard purchase order 6539, in the Line Details region, click the "Show All Details" link.
This displayed the shipments for each line.

In the environment prior to R12.2.9, Line 1 Shipment 1 shows:
- Qty Ordered = 1400
- Qty Received = 1400
- Qty Invoiced = 1400
- Amount Ordered = 350,000.00
- Amount Received = 350,000.00
- Amount Billed = 350,000.00
** This is correct data.

In the R12.2.9 environment, Line 1 Shipment 1 shows:
- Qty Ordered = 1400
- Qty Received = 1400
- Qty Invoiced = 1400
- Amount Ordered = 0.00
- Amount Received = (null)
- Amount Billed = 350,000.00
** The values for "Amount Ordered" and "Amount Received" are incorrect.

The issue is also noticed to occur in Oracle iProcurement, when viewing the PO details after searching from the Requisitions tab or Receiving tab.




Upgrade to Release 12.2.9 or 12.2.10.


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.