My Oracle Support Banner

Data Based Triggers for Campaigns do not get executed - ORA-06502: AMS_TRIG (Doc ID 297738.1)

Last updated on DECEMBER 04, 2019

Applies to:

Oracle Marketing - Version 11.5.9 to [Release 11.5]
Information in this document applies to any platform.


The workflow background process 'OMO Triggers' launches the following errors:

Workflow errors: AMS_TRIG, 1004426112004172549
Failed Activity: Generate and Execute Schedules
Activity Type: Function
Error Name: -6502 [Error Process Error: WF
Error Message: ORA-06502: PL/SQL: Numeric or value error:
character string buffer too small [ERROR Process Error: 3114: Activity
'WFERROR/DEFAULT' is not a process.]
Error stack: Wf_Directory.GetRoleName(PER, PER) Wf_Engine_Util.Function_Call
141528, RUN) [Error Process Error: Wf_Engine.CreateProcess(WFERROR, WF302308,DEFAULT)]

The database triggers do not get executed.

1. Log into OMO
2. Navigate to Campaigns
3. Create a campaign
4. Create a trigger for this campaign
Type = Date Based
5. Check for the trigger execution.


To view full details, 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 a vibrant support community of peers and Oracle experts.