My Oracle Support Banner

PO Upload Taking A Long Time (Doc ID 2955162.1)

Last updated on JUNE 14, 2023

Applies to:

Oracle Retail Merchandising Foundation Cloud Service - Version 19.3 to 19.3 [Release 19.3]
Information in this document applies to any platform.

Symptoms

While doing a data migration trial and using PO uploader to migrate POs. It has been noticed that in this cycle it is taking a long time to upload orders that have several hundred rows which is impacting the total load time.
For example process id 2305006 has an order with 904 rows which it has been processing for 30+ minutes, the other 9000 rows for others orders loading very quickly.

Example:
there are multiple Orders in a file, and one of the orders has a large number of details which seems to be causing a delay.


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. ODS file that includes many Orders (POs) and at least one with a large number of details
2. Upload to RMS via Upload process
3. Notice huge performance issue

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.