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 laterInformation 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):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 |