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

Last updated on APRIL 22, 2024

Applies to:

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

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