My Oracle Support Banner

ELA9.2: Upon Retirement of Asset After a Back Dated Lease Amendment Getting "SQL error in Exec. (2,280)" Error (Doc ID 2663047.1)

Last updated on APRIL 03, 2024

Applies to:

PeopleSoft Enterprise FIN Lease Administration - Version 9.2 to 9.2 [Release 9]
PeopleSoft Enterprise FIN Asset Management - Version 9.2 to 9.2 [Release 9]
Information in this document applies to any platform.


Getting an error on retirement of Lease Asset after a back dated amendment is processed.

The issue can be reproduced at will with the following steps:

1. Operating Lease created for 1 year & processed for 5 periods.
2. Added a backdated amendment to increase base rent with transaction date 01st Apr & Accounting date 01st jun.
3. Process Lease for 6 period.
4. Retire Lease with accounting date as 1st Jul and Transaction date as 1st Feb

Please see replication screenshots for more detailed steps.

Note: If getting similar error while activating lease amendment, then please review <Document 2663726.1>




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

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