I found it. It did relate to the bursting definition and was because I used the wrong layout / report name in one of the parameters.

Hi Shukla, Thank you for responding. What do you mean when you say template. I am working on OBIEE BI Publisher rather than XML publisher in Oracle E-business Suite. In OBIEE BI Publisher the report layout works fine as we have sample data generated from the data model. Therefore, all looks like it works apart from when I…

Hi Sherry. Thank you again . I should have used an SQL editor and I would have noticed.

Here is the data definition. We have referenced a subject area, rather htan a physical table, which has worked from a different area already. select "Employee Expenses"."Cost Center"."Cost Center Number" "KEY", 'Layout 1' TEMPLATE, 'en-US' LOCALE, 'PDF' OUTPUT_FORMAT, 'EMAIL' DEL_CHANNEL, "Employee Expenses"."Cost…

Hi Sherry I may need some more deeper administration help to provide the information that you have asked for. I am meeting an administrator tomorrow. Here is the bursting definition. Please note that we managed to get a BI Publisher report to send following some other solution that you provided about an 'Unresolved Table…

Hi Sherry, No of course not. How silly. I will retry it.

Hi Sherry, Thanks again. I have just a few more questions. Does this mean that I need to reference a technical table name, and that I am effectively joining this table to the data set, e.g. the Key field is what we are using to join the SQL query to the data set? If so, this would be useful as it would allow me not to need…

Hi Sherry. Thank you once more. I will have to ask admin for a table name that has the email addresses and a column for the Key field (in this case a business cost centre) within it. I will feedback once I have a new success or error message. Kind Regards Mark Hamilton

Hi Sherry Thank you so much for replying so soon. Here is the bursting definition.COLUMN13 has an email address within it. I have 2 different error messages. I get the "Unresolved Table" error shown in your comment if I change the layout name to the filename and I get a syntax error if I use the name 'layout1' shown below.…