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.

Symptoms

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

Changes

 The issue occurred after Enabling Audit Logging

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!

In this Document
Symptoms
Changes
Cause
Solution


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