No Data Source for PeopleSoft Pivot Grid

I was trying to create  a Pivot Grid but  the Pivot Grid Wizard is showing "Invalid Value" for the Data Source.I researched over this and found a solution on Oracle Support.


Solution:

The data for the table PSPGDTYPE needs to be imported into the database. This can be achieved by importing the \DATA\pspgdtype.dat file.

Before proceeding, check that the table PSPGDTYPE is empty.

The following steps can accomplish this :

1. Create a datamover script named pspgdtype_custom.dms with the following :

SET INPUT pspgdtype.dat;
SET LOG pspgdtype.log;
SET NO TRACE;

IMPORT *;

2. Log in to Data Mover using a valid OPRID ('PS', 'VP1') and run the pspgdtype_custom.dms script

3. Re-Query the table PSPGDTYPE to ensure there is now 1 row.
4. Stop the Application Server domain(s), Process Scheduler domain(s), and PeopleSoft Internet Architecture instance(s).
5. Clear caches on Application Server domain(s), Process Scheduler domain(s), and PeopleSoft Internet Architecture instance(s) and restart.

6. Verify the issue is resolved.