My Oracle Support Banner

ELA: Opening an Audit Log for a New Lease Throws "SQL error in Exec. (2,280) FS_AUDIT_LOGGING.AuditLogging.OnExecute" Error After Enabling Lease Administration Audit Logging With the “Include Archive” Checkbox Selected (Doc ID 2870526.1)

Last updated on MAY 18, 2022

Applies to:

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


After Enabling Lease Administration Audit Logging with the "Include Archive" checkbox selected, opening an Audit Log for a new Lease throws the following errors:

Popup Message (Error 1):

The issue can be reproduced at will with the following steps:
1. Enable Audit Logging for Lease Administration (Application Name: Real Estate Management) by selecting the required events
Navigation: Set Up Financials/Supply Chain > Common Definitions > Audit Logging > Enable Audit Logging
2. Check the "Include Archive" checkbox and Save
3. Open the Audit Log for a New Lease
Navigation: Lease Administration > Payables Leases > Maintain Payables Lease
4. The reported errors pop up


 The issue occurred after Enabling Audit Logging


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.