nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Oracle Communities

Oracle Analytics and AI

Child Item

Allow Multiple Values for Event Trigger Parameter

C. Joseph

As of Oracle Analytics Publisher 12.2.6.1.12, event triggers accept only one value in a parameter. If you pass multiple values to a schedule event trigger parameter, the status of the scheduled job is set to Skipped. We would like to request that trigger parameters accept multiple values to fulfill a requirement we have to pass multiple parameters for a trigger parameter for a scheduled job.

Find more posts tagged with

Submitted

OTBI

Event Triggers

Status: Submitted

Comments

MandeepGupta

Hi @C. Joseph ,

Thanks for the idea. Can you please provide an example or a use case?

Thanks.

C. Joseph

Allowing selection of multiple buyers would allow managers to schedule daily metrics related reports to run for the buyers in their organization. Hardcoding of buyers is not feasible. Similarly, allowing selection of multiple PO document styles (e.g., Subcontract, PO, etc.) specific to a buyer would be another use case. We have other columns that have been requested for multiple selection. In these cases, a false fail condition is generated if the scheduled report returns no data if a trigger is not used, so a schedule event trigger was considered. However, the report is skipped if a parameter is configured as multi-parameter even if data is returned by the trigger. Per Oracle documentation, this appears to be a limitation of event triggers.