@Syamantak Saha - I don't believe there is a standard report to retrieve this information unfortunately. The issue is functionality in Oracle allows for a work order to be saved without an associated work centre but then no means to identify where null. Id really appreciate any advice on how I might better tackle this…

Upvoted - This restriction really does impact reporting capabilities

@Riyaz Ali-Oracle - I used the below in the end. This returns all work orders without an operation therefore no work centre SELECT WWOB.WORK_ORDER_ID, WWOB.ORGANIZATION_ID, WWOB.WORK_ORDER_NUMBER, WWOT.WORK_ORDER_DESCRIPTION, WWOB.WORK_ORDER_SUB_TYPE, WWOB.WORK_ORDER_STATUS_ID, WWOB.PLANNED_START_DATE, WWOB.CREATION_DATE,…

@Riyaz Ali-Oracle - unfortunately the SQL returns an error. ORA-00942: table or view does not exist. I cross referenced some of the Table and Views and tried the below but still could not get it to work (error this time was ORA-00907: missing right parenthesis): SELECT wd.WORK_DEFINITION_HEADER_NAME AS…

@Riyaz Ali-Oracle Thank you for your response. To confirm, its the maintenance subject area we are using. I have tried something similar to the above but it appears the way OTBI behaves is that it defaults to an inner join and excludes the null values. When I apply a null filter to the work centre name the results are zero…