Complete a customized standard Schedule Process in 'Warning' in case of no values in custom columns

Question

I have customized the 'Print Commercial Invoice Report' and I would like to end the schedule process in warning if two new custom columns have no values. These columns are fetched in Data Model. Currently the report runs if the columns have no values. But, I would like to know if there is a way to complete the process in warning status.

Raghavan p-Oracle · Answer

Hi , @DhanashreeG

if data does not exist in a specific column, don't think any feature is available to make the report job fail with warn/error.

Alternatively, you may try adding a trigger in the data model.

https://docs.oracle.com/en/cloud/saas/otbi/otbi-pub-design/triggers.html

https://docs.oracle.com/en/cloud/saas/otbi/otbi-pub-design/create-schedule-triggers.html

In the trigger write a query to check for not-null on the respective custom columns. So that the job won't initiate which tells the users that there is no data in that respective columns.

Regards,

Raghavanexist