Oracle Schedule Agent discrepency compared to manual run
Hi,
We have encountered an issue regarding an OTBI scheduled Agent report where the output results differ significantly depending on how the report is run:
- Manual Run (via Dashboard): When the user manually runs the report directly from the dashboard, it generates the full, expected set of results.
- Scheduled Agent Run ("Run As"): When the Agent runs automatically using the exact same user account assigned in the "Run As" credential setting, the output only returns 3 rows.
The underlying analysis does not have restrictive prompts, dates, or hardcoded filters that would limit the date range or row count for a scheduled run.
Tagged:
0