Generate Direct Loan Data (FAPDLOUT) fails with ORA-01400: cannot insert NULL into ("SYSADM"."PS_SFA_COD_DISB"."SFA_CR_PGMLENYEARS") (Doc ID 2251624.1)

Last updated on APRIL 04, 2017

Applies to:

PeopleSoft Enterprise CS Financial Aid - Version 9 to 9 [Release 9]
Information in this document applies to any platform.

Symptoms

In Campus Solution 9, after applying the two most current COD patches..

Patch 24290724: 2017 - 2018 AID YEAR UPDATES FOR DIRECT LENDING COD AND PELL COD
Patch 25713933: DL DISBURSEMENT VALIDATION EDIT ERRORS RETURNED WITH COD CRITICAL PATCH

The Generate Direct Loan Data (FAPLDOUT) process fails with the following error...

Failed In Pgm Section : I-DISB (INSERT) With Return Code: 01400 Error Message : ORA-01400: cannot insert NULL into ("SYSADM"."PS_SFA_COD_DISB"."SFA_CR_PGMLENYEARS")


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