Performance Issue With Create Worksheet Order in Buyer Worksheet (Doc ID 2974229.1)

Last updated on SEPTEMBER 14, 2023

Applies to:

Symptoms

Performance issue with create worksheet order in buyer worksheet

Steps To Reproduce:

1) Make sure TSFDETAIL has over 40 million rows.
2) Make sure items are setup on replenishment using Dynamic Replenishment and Buyer Control and generate ROQs.
3) Enter Tasks -> Replenishment -> Buyer Worksheet
4) Search for Items
5) Choose an item with an Order Quantity
6) Create Worksheet Order -> Confirm 'Yes'
7) Notice the screen spins for minutes.

Cause

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