In Oracle iSupplier Portal and Oracle iProcurement, 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 JANUARY 07, 2024

Applies to:

Symptoms

In Oracle iSupplier Portal, 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.

User = OPERATIONS

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.

Changes

Upgrade to Release 12.2.9 or 12.2.10.

Cause

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