EAR9.1: AR_REVAL Process Failure With Unique Constraint Error (Doc ID 1939240.1)

Last updated on SEPTEMBER 21, 2016

Applies to:

PeopleSoft Enterprise FIN Receivables - Version 9.1 to 9.1 [Release 9]
Information in this document applies to any platform.

Symptoms

On : 9.1 version, AR_REVAL process failure with unique constraint (SYSADM.PS_RVL_AR_TAO11) violated error.

An item ID is causing unique constraint error every month. The offending item causing the issue is getting picked up again and again picked up at every month end process though it had been closed before.

ERROR
-----------------------
Process XXXXXX ABENDED at Step AR_REVAL.BLDTMP.BLDBUA (Action SQL) -- RC = 805
ROLLBACK
/
SQL Error: ORA-00001: unique constraint (SYSADM.PS_RVL_AR_TAO11) violated

STEPS
-----------------------
The issue can be reproduced at will with the following steps:

  1. Create a deposit with control currency and payment currency as EUR for about 100 EUR for the business unit with the base currency as GBP.
  2. Apply the payment to an invoice of the business unit with the base currency as USD for about 90 EUR and the remaining 10 EUR on account payment to a business unit with the base currency as USD.
  3. Create Payment Worksheet.
  4. Apply the payment to an invoice of the business unit with the base currency as USD for about 90 EUR and the remaining 16.94 EUR on account payment to a business unit with the base currency as USD.
  5. Create Accounting Entries.
  6. Finalize Worksheet.
  7. Run AR Update process.
  8. Run AR_REVAL process.


BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, an item ID is causing unique constraint error every month. The offending item causing the issue is getting picked up again and again picked up at every month end process though it had been closed before.

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