My Oracle Support Banner

Fusion BI Publisher Schedule Trigger Schedule Job Status Skipped When Multiple Values Are Passed to A Parameter (Doc ID 2780661.1)

Last updated on MAY 30, 2021

Applies to:

Oracle Fusion Global Human Resources Cloud Service - Version 11.13.21.01.0 and later
Oracle Fusion Financials Common Module Cloud Service - Version 11.13.19.10.0 and later
Information in this document applies to any platform.

Symptoms

1. Create a new Data Model
2. Under Properties, click on 'Event Triggers'
3. Create a new 'Event Trigger' with Type - Schedule
4. Use the below SQL:

SELECT distinct 'true'
FROM DUAL
WHERE EXISTS(SELECT * FROM per_all_people_f papf
WHERE 1=1
AND ( (papf.person_number IN (:p_person_number))
))

5. Save the data model
6. Create a new report
7. Schedule the report
8. Go to Schedule tab
9. Under Parameters section, pass 2 values for a parameter using Comma
10. Click on Submit
12. Go to Report Job History. Job shows status - Skipped.

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
Cause
Solution


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