My Oracle Support Banner

ELA: RE_RENT_VAR Process To Fail Due To Unique Constraint For Amendments (Doc ID 2393576.1)

Last updated on JUNE 05, 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

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
Changes
Cause
Solution
References


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