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