EEX 9.2: Delivered Expenses BI Reports Run To No Success Due To SQL Error
(Doc ID 2410450.1)
Last updated on APRIL 21, 2020
Applies to:
PeopleSoft Enterprise FIN Expenses - Version 9.2 to 9.2 [Release 9]Information in this document applies to any platform.
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
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
| Symptoms |
| Cause |
| Solution |
| References |