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 APRIL 28, 2021

Applies to:

Oracle iSupplier Portal - Version 12.2.9 and later
Information in this document applies to any platform.

Symptoms

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


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.


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

 

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
Changes
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.