My Oracle Support Banner

E1: 47: Performance Issues with EDI Inbound Purchase Order Edit/Create (R47011) (Doc ID 2537398.1)

Last updated on MAY 01, 2019

Applies to:

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

Symptoms

EDI Inbound Purchase Order Edit/Create (R47011)

Performance of EDI Inbound Purchase Order Edit/Create (R47011) is being slowed down by the Business Function GetItmLocByCommitment (B4000780), which is reading Item Location (F41021) records even though availability checking is bypassed in the processing options of the Sales Order Entry (P4210) version called.

This is impacting all the orders from one customer in one particular business unit. This customer processes 100 EDI orders a day and performance degradation is delaying order processing for this key customer.

Facts gathered from WebEx conference and Log Analysis

  1. EDI Inbound Purchase Order Edit/Create (R47011) Version CAVSU002 calls Sales Order Entry (P4210) Version CAV00015
  2. Sales Order Entry (P4210) Version CAV00015 has Availability Checking turned off
  3. EDI Inbound Purchase Order Edit/Create (R47011) Version CAVSU002 took 38 minutes to process
  4. The job took 38 minute to process 5 orders with a total of 12 lines between them, taking more than 3 minutes per order line processed
  5. The issue occurs when there are a lot of Item Location records connected with the order.
  6. One of the jobs analyzed spent 95% of its time in the Business Function GetItmLocByCommitment (B4000780), which was reading F41021 records.

Where the issue happens
The issue occurs in the production (live) environment.

Expected or acceptable result
If availability checking is turned off, the Business Function GetItmLocByCommitment (B4000780), should not be spending time reading Item Location (F41021) records to check available quantities.

Changes

 

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.