My Oracle Support Banner

Spreadsheet Export From Supplies and Demands is Exporting More Records Than is Seen in the User Interface (Doc ID 2484049.1)

Last updated on NOVEMBER 08, 2019

Applies to:

Oracle Fusion Planning Central Cloud Service - Version 11.13.18.10.0 and later
Information in this document applies to any platform.

Goal

When any type of search condition is used in the Supplies and Demands table, the returned data on UI is correct.
However when the data is exported to a Spreadsheet there are many more records exported than what is seen in the UI.

Example
Search for Planned Orders for 1 specific item.
The query returns 2 records in the UI.
Then when the export icon is clicked, the Excel spreadsheet contains 15 records.
The additional 13 records may contain different items and different order types.

The above example becomes exponentially larger if there are hundreds of lines returned by the query in the UI.
So when reviewing the data in the spreadsheet it becomes very confusing when there are thousands of lines that contain many different items and order types.

What causes this type of issue and how can the exact data/records seen in the UI be exported to the spreadsheet?
 

Solution

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
Goal
Solution


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