Cannot Reverse Specific Receipt: Screen Keeps Asking to Save Changes and does not Reverse the Receipt (Doc ID 2754250.1)

Last updated on MAY 20, 2024

Applies to:

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

When user tries to reverse a specific receipt, the reversal does not happen. There is no error and the form keeps asking to save the changes

Steps to Reproduce:

Responsibility: Receivables responsibility
Navigation: Receipts > Receipts

Query Receipt Number with the issue
Click on Reverse button
Enter all information and Save
There are no errors; when user tries to exit the form, it keeps asking if they want to save changes until they click "No"
Go to the form again, query the same receipt and it is not reversed

FND Debug shows the following, under MESSAGE_TEXT column:

For the rows of the FND Debug in bold above, the column ERRORSTACK shows the following:

ORA-00001: unique constraint (AR.AR_CASH_RECEIPT_HISTORY_U2) violated

	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

Symptoms

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