E1: 42: P40339 Product Allocation Profiles Has Slow Performance When Adding New Records (Doc ID 2145144.1)

Last updated on MAY 08, 2017

Applies to:

JD Edwards EnterpriseOne Sales Order Processing - Version 9.0 and later
Information in this document applies to any platform.

Symptoms

When having over 3800 records in the F40339-Product Allocation Profiles file, adding a new record through the P40339-Product Allocation Profiles application results in a display showing the records being listed from record 2000 (2010, 2020...) and so on until the last record.
System is taking over 1 minute (approximately 75 seconds) until the Add form is displayed. Frequency of records counted is almost 20recs/sec.

 

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms