AR Receipt Application Screen Hangs For Invoices With A Large Number Of Lines (Doc ID 2052959.1)

Last updated on APRIL 18, 2016

Applies to:

Oracle Receivables - Version 12.1.1 and later
Information in this document applies to any platform.

Symptoms

On : 12.1.2 version, Receipts Related

ACTUAL BEHAVIOR
---------------
User has performance problems when trying to apply a receipt to imported transactions with 88k lines.
Application takes more then 3h trying to apply the receipt.
System behaves normally for the invoices with less number of lines.

EXPECTED BEHAVIOR
-----------------------
User expects a reasonable time amount for applying a receipt to a transaction even if transaction has more then 80.000 lines.

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Import transaction with 80.000 lines
2. Create a receipt
3. Try to apply receipt to the transaction -> performance issue

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot close balances on imported transactions.

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms