My Oracle Support Banner

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 and later
Information in this document applies to any platform.


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

"The cash receipt ID takes precedence over the receipt number. (AR-855741)"
"REVERSE: ORA-00040: active time limit exceeded - call aborted (AR-855636)"
 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


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

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