My Oracle Support Banner

E1: 47: EDI Inbound 850 R47011 Performance Issue - Update to Code for 9.2 to Function More Like Release 9.0 (Doc ID 2735989.1)

Last updated on JANUARY 19, 2021

Applies to:

JD Edwards EnterpriseOne EDI - Version 9.2 and later
Information in this document applies to any platform.

Symptoms

Since upgrading from 9.0 to 9.2, the UBE R47011 EDI Inbound 850 Batch SO creation performance has degraded around 10x slower.

 

Changes

The PreferenceGetValuesForSalesOrder BSFN (B4002060.C) was modified between 9.0 and 9.2 to terminate a cache at the end of the function. This was done to eliminate the 'leak' of a single cache, but it caused the total runtime of all the calls to this BSFN to go from 1.148339 seconds for 327 calls in 9.0 to 12.414768 seconds for 279 calls in 9.2.A request was made to modify 9.2 PreferenceGetValuesForSalesOrder BSFN (B4002060.C) code to match the 9.0 code where in 9.0 code the jde cache was not terminated by apps code and was terminated by tools code during free environment.

The comment for that function reads:
* Business Function: PreferenceGetValuesForSalesOrder
*
* Description: Preference Get Values For Sales Order - This function
* will determine the preferences for a Sales Order Detail Line. The
*preference retrieval information is contained in files F40070,
F40072,
*and F40073. The preference details are held in F40301 - F40313.

With the above, terminate this cache is actually causing lots of soft table accesses to that table and too much database access causing performance issues.

 

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
Changes
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.