R12/CE: Low Performance Speed When Searching For An AR Receipt in the Cash Management (Doc ID 2139808.1)

Last updated on DECEMBER 08, 2023

Applies to:

Symptoms

Performance problem in Cash Management when searching for an individual AR receipt in the
"Find Transactions" window invoked from the Bank Statements Line form.
It used to take under a minute. Now, even after 20 minutes, the information is not displayed and the session has to be killed.

ADDITIONAL INFORMATION
--------------------------
- Able to search for receipts by batch without any issues
- Issue is when searching for an individual receipt.


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Go to Cash Management responsibility ( ie. SS CM Managers )
2. Click on "Enter/Reconcile Bank Statements"
3. Choose one bank statement and click on REVIEW button
4. In the Bank Statement form, click on LINES
5. Move to one line that Status = Unreconciled
6. Click on AVAILABLE button
7. In the "Find Transactions" window, as a search criteria,
  Check the checkbox [x]AR Receipt
  Transaction Number from : 2484
  Transaction Number to : 2484
8. Click on FIND button

Changes

 forms/US/CEXCABMR.fmb 120.194.12010000.111

Cause

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