EEX 9.2: Delivered Expenses BI Reports Run To No Success Due To SQL Error

Last updated on JUNE 14, 2018

Applies to:

Symptoms

Delivered Expenses BI Reports Run to No Success due to Error  

Steps:
--------
The issue can be reproduced at will with the following steps:
1. Run the below processes with and without Department ID in runcontrol page.
Navigation
1. NavBar > Navigator > FSCM > Travel and Expenses > Manage Accounting > Print Reports > Standard Budgets
        Process Name:  EX_BUDG_XRPT

2. NavBar > Navigator > FSCM > Travel and Expenses > Manage Accounting > Print Reports > Employee Average Expenses
Process Name: EX_AVEM_XRPT

3. NavBar > Navigator > FSCM > Travel and Expenses > Manage Accounting > Print Reports > Employee Trends
Process Name: EX_ETRD_XRPT

4. NavBar > Navigator > FSCM > Travel and Expenses > Manage Accounting > Print Reports > Top Spenders
Process Name: EX_ESPD_XRPT

5. NavBar > Navigator > FSCM > Travel and Expenses > Manage Accounting > Print Reports > Non-Reimbursable Expenses
Process Name: EX_NONRB_RPT

Error:
-------
1. If the reports are ran without the department id blank it will result in a “not in a Group By expression Failed SQL” error,

2. If the reports are ran with the department id populated it will result in a “column ambiguously defined Failed SQL”

Cause