ELA: RE_RENT_VAR Process To Fail Due To Unique Constraint For Amendments

(Doc ID 2393576.1)

Last updated on MAY 01, 2018

Applies to:

PeopleSoft Enterprise FIN Lease Administration - Version 9.2 and later
Information in this document applies to any platform.

Symptoms

On : 9.2 version, PI # 21. 2.4 Lease Maintenance

Amendments causing Base Rent, Op-EX and Misc. Expense to be reversed and generated again.

When our Lease Administration team input any amendments related to Financial, it causes each line in the Recurring payment schedule( Base Rent, Op-EX and Misc.Exp) to be reversed and generated again. This is causing the RE_RENT_VAR process to fail due to unique constraint.

ERROR
-----------------------
Unique constraint error (PS_RE_PRIVAL-TAO6) INSERT INTO PS_RE_PRIVAL_TAO6.

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
Lease Administration team input any amendments related to Financial, it causes each line in the Recurring payment schedule( Base Rent, Op-EX and Misc.Exp) to be reversed and generated again.



Changes

 

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