My Oracle Support Banner

EEX 9.2: Delivered Expenses BI Reports Run To No Success Due To SQL Error (Doc ID 2410450.1)

Last updated on JUNE 14, 2018

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!


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.