My Oracle Support Banner

ELA: SYSADM.PS_RE_FASB_TAO4 RE_FASB_GEN.TRANSCH.MIDPD ERROR On Lease (Doc ID 2393880.1)

Last updated on MAY 02, 2018

Applies to:

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

Symptoms

RE_FASB_GEN failed with unique constraint error when Renewal option payment is added.

1. Create a lease with an asset for 12 months
2. Add a base rent of $1000
3. Add Renewal option in Option and Critical Dates page
4. Add Renewal option payment amount $1500
5. Activate the lease
6. Run Manage Transaction generator process
7. Run Generate Straight line schedule

Error:
-------
Process failed with error:
Stmt #: 1723 Error Position: 0 Return: 805 - ORA-00001: unique constraint (SYSADM.PS_RE_FASB_TAO4) violated
Failed SQL stmt: INSERT INTO PS_RE_FASB_TAO4.................................

Process 24661 ABENDED at Step RE_FASB_GEN.TRANSCH.MidPD (SQL) -- RC = 805 (108,524)


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!

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