E-PG: "No Data to display" Message When Filtering Data On Blank Values (Doc ID 1952237.1)

Last updated on DECEMBER 29, 2014

Applies to:

PeopleSoft Enterprise PT PeopleTools - Version 8.53 and later
Information in this document applies to any platform.

Symptoms

Pivot Grid is not filtering data for Blank values.

Error
----------
The following error message is received when running a pivot grid with Blank values:

"No data to display."

Steps
------------
In order to reproduce the issue, follow the below steps:

1. Login into PIA.

2. Create query TEST with the below Query SQL

SELECT A.CASE_ID, A.DEPTID, A.LOCATION, TO_CHAR(A.CREATION_DATE,'YYYY-MM-DD'), C.BUSINESS_UNIT
 FROM ((PS_RC_CASE A LEFT OUTER JOIN PS_RD_PERSON B ON A.BO_ID_CUST = B.BO_ID ) LEFT OUTER JOIN PS_JOB C ON C.EMPLID = B.EMPLID )
 WHERE ( A.CREATION_DATE BETWEEN TO_DATE(:1,'YYYY-MM-DD') AND TO_DATE(:2,'YYYY-MM-DD') )

3. Dates returned by running the query.

Date - Start Date = 2014-11-24,Date - End Date=2014-11-27

   Case    DeptID Location  Created       Unit
1 223565 KC001   KUCA00 11/26/2014
2 223563 KC001   KUCA00 11/26/2014
3 223562 KC001   KUCA00 11/25/2014
4 223559 KU0000 L00001 11/25/2014
5 223561 KU0000 L00001 11/25/2014
6 223560 KU0000 L00001 11/25/2014
7 223567 54000              11/27/2014 AUS01
8 223566 42000  KUNY00 11/27/2014

4. Create pivot grid TEST.

For Unit Field, only "(Blanks)" value is selected and results are showing "No Data to display" which is wrong.

Cause

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 hundreds of Community platforms