Importing Pell LEU and Pell SAS files error on DB2

(Doc ID 2383626.1)

Last updated on APRIL 06, 2018

Applies to:

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

Symptoms

After applying CS 9.0 Bundle #48, when attempting to import either a Pell LEU or a Pell SAS file the process errors on DB2


ERROR
-----------------------

INSERT INTO PS_MESSAGE_LOGPARM (PROCESS_INSTANCE, MESSAGE_SEQ, PARM_SEQ, MESSAGE_PARM) VALUES(:1, :2, :3, :4)
386 13.18.55 0.000000 Cur#1.8048.CS9PNF RC=0 Dur=0.000000 Bind-1 type=8 length=4 value=2240779
387 13.18.55 0.000000 Cur#1.8048.CS9PNF RC=0 Dur=0.000000 Bind-2 type=8 length=4 value=1
388 13.18.55 0.000000 Cur#1.8048.CS9PNF RC=0 Dur=0.000000 Bind-3 type=8 length=4 value=1
389 13.18.55 0.000000 Cur#1.8048.CS9PNF RC=0 Dur=0.000000 Bind-4 type=2 length=100 value=Error opening the file - /psoft/fileserver/cs9pnf/icc/interface/FA/Pell17-18/pgle18op.001 (14015,643
390 13.18.55 0.000000 Cur#1.8048.CS9PNF RC=0 Dur=0.000000 Bind-1 type=8 length=4 value=2240779
391 13.18.55 0.000000 Cur#1.8048.CS9PNF RC=0 Dur=0.000000 Bind-2 type=8 length=4 value=1
392 13.18.55 0.000000 Cur#1.8048.CS9PNF RC=0 Dur=0.000000 Bind-3 type=8 length=4 value=2
393 13.18.55 0.000000 Cur#1.8048.CS9PNF RC=0 Dur=0.000000 Bind-4 type=2 length=1 value=)
394 13.18.55 0.001000 Cur#1.8048.CS9PNF RC=0 Dur=0.001000 Commit
395 13.18.55 0.000000 Cur#1.8048.CS9PNF RC=0 Dur=0.000000 Disconnect
(14015,643)




STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1a. Financial Aid --> Pell Payment --> LEU Reports --> Import LEU Files

or

1b. Financial Aid --> Pell Payment --> Cash Management Reports  --> SAS Reports --> Import SAS Files

2. Create a new Run Control ID or use an existing one
3. Run the process
4. Review the results


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