Logging In XLA_EVENTS_PKG And XLA_EVENTS_PUB_PKG At Level 20 (Doc ID 1665402.1)

Last updated on MARCH 08, 2017

Applies to:

Oracle Financials Accounting Hub - Version 12.1.3 and later
Information in this document applies to any platform.

Symptoms

On : 12.1.3 version, Other Issues

The XLA_EVENTS_PKG and XLA_EVENTS_PUB_PKG package code has what appears to be entry/exit logging set to log incorrectly at level 20 instead of level 2.

Since you can only set the profile option FND: Debug Log Level option (AFLOG_LEVEL) to a maximum of 6, you cannot prevent this logging from XLA_EVENTS_PKG and XLA_EVENTS_PUB_PKG, while still recording unexpected errors.

This is generating hundreds of thousands of FND_LOG_MESSAGES records that are effectively just rubbish, wasting space and making it hard to find records for real problems.

The logging should be set at level 2 instead of 20.

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms