My Oracle Support Banner

Is there a limitation that WMS can give only 200,000 rows in one CSV export ? (Doc ID 2478272.1)

Last updated on JULY 27, 2020

Applies to:

Oracle Warehouse Management Enterprise Edition Cloud Service - Version 9.0.0 and later
Information in this document applies to any platform.

Goal

Background:

------------

While exporting data from any screen in WMS such as IBLPN, OBLPN, WMS gives exactly only 200,000 records.

There are over 200,000 IBLPNs in total and these are increasing everyday exponentially. However when customer displays all IBLPNs and use ' Export to CSV ' or ' Export to CSV (offline) ' option, it gives us the most recent 200,000 records in csv export file and skips the old records.

While exporting today, it gave us records from Feb-2018 till today, as customer moves ahead and will export the data lets say in December 2018, it may give us data from March-April 2018 and skip the old records.
Customer needs to export records on daily basis and need the ability to export all records may them be 500,000

Is there a limitation that WMS can give only 200,000 rows in one CSV export ?
 

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
References


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