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

Last updated on MAY 15, 2023

Applies to:

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.
   
   
   

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.