Oracle Procurement Cloud BIP Report - Does trigger require parameters unique to the trigger SQL?

C. Joseph

Summary:

Trigger SQL returned no data when sharing the same parameter with the report logic.

Content (please ensure you mask any confidential information):

We are using a trigger for a scheduled BI Publisher report to skip the report run when no data is returned by the trigger SQL. We have 2 parameters that are used by both the trigger SQL and the report logic. When we used the same parameter in both the trigger SQL and the report SQL, the trigger never returned data and always skipped the report even though the trigger logic returned data. I created unique parameters for the trigger, and that resolved the issue. However, when users are prompted for the parameters, they now have to fill in the same value for both the trigger parameter and the corresponding report parameter. Is this correct? Is there a better approach?

Version (include the version you are using, if applicable):

Oracle Procurement Cloud V24C

Code Snippet (add any code snippets that support your topic, if applicable):

C. Joseph

We've traced the issues we were having to a trigger parameter that allows multiple values. We discovered that multiple values are not supported for triggers. The parameter will be converted to a text field which will allow only one value. Unfortunately, this will require the job to be scheduled for each value, which is not ideal. An idea has been submitted to allow event trigger parameters to accept multiple values.

Allow Multiple Values for Event Trigger Parameter — Oracle Analytics