iSupplier Portal View Shipments has incorrect Quantity Received And Shipped Quantity against the Shipment (Doc ID 2074526.1)

Last updated on NOVEMBER 05, 2015

Applies to:

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

Symptoms

ACTUAL BEHAVIOR

When viewing the Advance Shipment Notice(ASN) Quantity Received and Shipped Quantity is showing incorrect Values in iSupplier portal

EXPECTED BEHAVIOR

Quantity Received and Quantity Shipped should show correct values against the shipment.

STEPS TO REPLICATE

The issue can be viewed will with the following steps:

  1. iSupplier portal full access responsibility (also in iSupplier Internal view Responsibility)
  2. Shipments –> Shipment Notice (ASN)
  3. Search Purchase Order(PO) -> Click on Shipment Number( ASN which is already created)
  4. Order Quantity , Quantity Received are showing wrongly


This is happening only In the below scenario

if Standard PO or release is partially received then revision is done in Blanket Purchase Agreement(BPA)
or standard PO and after revision we again receive the Qunatity ,then Quantity received will not show correct in iSupplier because once revision
is done then row insert into PO_Line_Location_archive table with old details means now in Archive table Quantity received is not 0 ,

So as per code if Archive table Received Quantity is not 0 then it will pick Received Qty.

 


Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms