My Oracle Support Banner

E1: 47: EDI Inbound Purchase Order Change (R47131) Slow Performance Due To Excessive I/O (Doc ID 2464945.1)

Last updated on OCTOBER 25, 2018

Applies to:

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

Symptoms

EDI Inbound Purchase Order Change (R47131)

When EDI Inbound Purchase Order Change (R47131) job is run on the scheduler, it is taking longer than expected to run. Last week it was taking 10-15 minutes to run. Yesterday it was taking more than 30 minutes to run. Performance is twice as slow.

The customer believes the slow performance is due to excessive numbers of SQL SELECTS (I/Os) on the Preference Master File (F40070) table and the Table Sharing - Table Group Detail (F95311) table.

The issue was reproduced at will with the following steps:

  1. A version of EDI Inbound Purchase Order Change (R47131) is scheduled to run every 30 minutes throughout the day
  2. After the job is started, a user turns Debug Logging ON during Job Execution Detail
  3. After a minute, the user turns Debug Logging ON during Job Execution Detail
  4. The user retrieves the debug logs and is able to determine the number of SELECTS as follows:
    1. There were 9705 SELECT statements processed against the Preference Master File (F40070)
    2. There were 5073 SELECT statements processed against the Table Sharing - Table Group Detail File (F95311).
  5. When the user checked Work with Submitted Jobs the job took 44 minutes (Start: 12:12:00 End:12:56:12)

This batch is scheduled to run every 30 minutes but when it takes more than 30 minutes to run, it delays the start of the next batch.

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.