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

Last updated on FEBRUARY 03, 2019

Applies to:

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

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