My Oracle Support Banner

PRC: PON: Import Award By Spreadsheet Not Reflecting When Using Filters (Doc ID 2676314.1)

Last updated on JUNE 12, 2020

Applies to:

Oracle Fusion Sourcing Cloud Service - Version 11.13.20.01.0 and later
Oracle Fusion Sourcing - Version 11.13.20.01.0 and later
Information in this document applies to any platform.

Symptoms

User had exported the award spreadsheet and since it had many lines, applied filter while the sheet was not in unprotected mode.

After entering the award quantity the imported spreadsheet did not reflect the quantities entered.

Steps to Reproduce:
Once all the Suppliers have responded, user want to Award by Spreadsheet

Case 1:
Award Negotiation -> Click Award by Spreadsheet
Export -> Open spreadsheet -> Go to Lines Summary tab
Under Rank column (value 1) -> Filter by column values
This will show all Lines for the Suppliers with Rank 1
Update the Award Quantity for one line from 300 to 10
Save and Import
Go to Award section -> Check the line
Quantity still shows 300

Case 2:
Award Negotiation -> Click Award by Spreadsheet
Export -> Open spreadsheet -> Go to Lines Summary tab
For the same line as above, Rank 1, update the Award Quantity from 300 to 10
Save and Import
Go to Award section -> Check the line
Quantity updated to 10

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