Process NSLDS Files FAPTALRT Error 8006 Invalid Datatype Specified with CCPSRCHP (Search/Match)

(Doc ID 2347994.1)

Last updated on JANUARY 11, 2018

Applies to:

PeopleSoft Enterprise CS Financial Aid - Version 9 and later
Information in this document applies to any platform.

Symptoms

On : CS 9.0 or later

When attempting to run Process NSLDS Files - the FAPTALRT cobol process -
the following error occurs.

ERROR
-----------------------
Application Program Failed
Action Type : SQL SELECT
In Pgm Section : SQLRT: EXECUTE-STMT
With Return Code: 08006
Error Message : Invalid datatype specified
Dynamic Stmt : DYNAMIC
SQL Statement : SELECT DISTINCT A.EMPLID FROM PS_PERSON A, PS_PERS_NID B, PS
_NAMES C, PS_NAMES D, PS_PERS_NID E, PS_NAMES F WHERE A.EMPL
ID = B.EMPLID AND B.NATIONAL_ID = '453613962' AND A.EMPLID =
C.EMPLID AND C.LAST_NAME_SRCH LIKE 'PAGE%' AND A.BIRTHDATE
= TO_DATE('1982-08-21', 'YYYY-MM-DD') AND A.EMPLID = D.EMPLI
D AND D.FIRST_NAME_SRCH LIKE 'LAURA%' AND D.FIRST_NAME_SRCH
LIKE :05# AND A.EMPLID = E.EMPLID AND E.NATIONAL_ID = :06# A
ND A.EMPLID = F.EMPLID AND F.LAST_NAME_SRCH LIKE :07# AND A.
BIRTHDATE = :08#�

at pos 00021
at pos 00021
at pos 00021
at pos 00021
at pos 00021
at pos 00021
at pos 00021
at pos 00021
at pos 00021
at pos 00021

Application Program Failed
In Pgm Section : DYSQL (40100-SELECT-ID)
With Return Code: 08006
Error Message : Invalid datatype specified

SQL Error W/CCPSRCHP @ 10:38:33.92 !



STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Run process

WHAT IS WORKING
-----------------
The process may run to success when switching to a different search parameter in the NSLDS Data Load Parameters setup - Setup SACR > Product Related > Financial Aid > File Management > NSLDS Data Load Parameters. NSLDS Search/Match tab.

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