Cannot Reverse Cash Receipt that has more than 5000 Applications with ORA-00040 (Doc ID 2036599.1)

Last updated on FEBRUARY 09, 2017

Applies to:

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

Symptoms

When attempting to reverse a cash receipt that has more than 5000 applications,
the following error occur:


ERROR
-----------------------
"The cash receipt ID takes precedence over the receipt number. (AR-855741)"
"REVERSE: ORA-00040: active time limit exceeded - call aborted (AR-855636)"
"FND-FND_AS_UNEXPECTED_ERROR (FND--1)
 FND-FND_AS_UNEXPECTED_ERROR
 Cause The message, FND-FND_AS_UNEXPECTED_ERROR, can not be accessed."


STEPS to Reproduce:
1. Search cash receipt on Manage Receipts UI
2. Actions > Reverse
3. Enter information for reverse
4. Click Reverse button




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