My Oracle Support Banner

E1:41: Automatic Inventory to G/L Reconciliation Report (R41500) Has Slow Performance (Doc ID 2629839.1)

Last updated on JANUARY 16, 2020

Applies to:

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

Symptoms

Performance is too slow on the Automatic Inventory to G/L Reconciliation Report (R41500) Report. Automatic Inventory to G/L. For example it is taking 15 seconds to reconcile 5 Work Order Completion transactions (3 seconds per transaction). At this rate, 10,000 transactions per day would take 30,000 seconds which equates to 500 minutes or 8.3333 hours.

The issue can be reproduced at will with the following steps:

  1. Select 5 IC transactions from today's work for processing.
  2. Run the the Automatic Inventory to G/L Reconciliation Report (R41500) Report with data selection on the 5 document numbers and capture logs.
  3. Check the Submitted Job Execution Detail which shows it took 15 seconds to reconcile 5 transactions or 3 seconds per transaction.
  4. Review the logs which shows F4111ToF0911Reconciliation (B4100960) business function is executed 5 times and takes more than one second for each execution.


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.