ELA: SYSADM.PS_RE_FASB_TAO4 RE_FASB_GEN.TRANSCH.MIDPD ERROR On Lease
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.
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
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)
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms