My Oracle Support Banner

EBS AMP: EBS Database Alert Log Reports "WARNING: too many parse errors" on Package Body "APPS.FND_OAM_EM.GET_WF_AGENT_ACTIVITY" (Doc ID 2995261.1)

Last updated on DECEMBER 28, 2023

Applies to:

Application Management Pack for Oracle E-Business Suite - Version 13.1.1.1.0 and later
Information in this document applies to any platform.

Symptoms

Database alert log reports multiple parse warnings in an instance where E-Business Suite(EBS) is configured with Application Management Pack (AMP). These errors are reported randomly and no operation is performed. Internally the warnings are caused due to user EM_MONITOR and on package body APPS.FND_OAM_EM.GET_WF_AGENT_ACTIVITY.

ERROR
----------

Below warnings are reported in the alert.log due to EM_MONITOR user.

EBSXXXX(3):WARNING: too many parse errors, count=10939 SQL hash=0xc5aeb26c
EBSXXXX(3):PARSE ERROR: ospid=390289, error=942 for statement:
EBSXXXX(3):Additional information: hd=0xc49c65360 phd=0xc49fb5e98 flg=0x101476 cisid=253 sid=253 ciuid=327 uid=327 sqlid=4s11tbg2uxcmc
EBSXXXX(3):...Current username=EM_MONITOR
EBSXXXX(3):...Application: emagent_SQL_oracle_ebs Action: Agent Activity
2023-12-01T13:12:45.307363-08:00
EBSXXXX(3):----- PL/SQL Call Stack -----
 object      line  object
 handle    number  name
0xc1b3990b8      3049  package body APPS.WF_QUEUE.GETCNTMSGST
0xc1b7f5e70        93  package body APPS.FND_OAM_EM.GET_WF_AGENT_ACTIVITY
0xc1b24dca0         5  anonymous block



STEPS
-----------------------
1. EBS configured with AMP 13.4.1.0.
2. Monitor the database alert log.

Changes

 

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
References


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