Process Loan Adjustments (FAPLBOG1) fail after the application of CS 9 Bundle #40 (Doc ID 2102660.1)

Last updated on MARCH 25, 2016

Applies to:

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

Symptoms

After applying CS 9 Bundle #40 (Patchset  21378905), when running Process Loans Adjustments (FAPLBOG1), the process fails with the following error...

Application Program Failed
 Action Type     : SQL UPDATE
 In Pgm Section  : SQLRT: EXECUTE-STMT                                 
 With Return Code: 01407
 Error Message   : ORA-01407: cannot update ("SYSADM"."PS_LOAN_ADDRESS"."STATE") to NULL
 Stored Stmt     : FAPLDAD2_U_LNADDR

SQL Statement   : UPDATE PS_LOAN_ADDRESS SET COUNTRY = :1, ADDRESS1 = :2, ADDR
                   ESS2 = :3, ADDRESS3 = :4, ADDRESS4 = :5, CITY = :6, NUM1 = :
                   7, NUM2 = :8, HOUSE_TYPE = :9, COUNTY = :10, STATE = :11, PO
                   STAL = :12, GEO_CODE = :13, IN_CITY_LIMIT = :14 WHERE EMPLID
                    = :15 AND       INSTITUTION = :16 AND       AID_YEAR = :17
                   AND       ACAD_CAREER = :18 AND       LOAN_TYPE = :19 AND   
                       LN_APPL_SEQ = :20 AND       LN_ADDR_TYPE = :21

 
Application Program Failed
 In Pgm Section  : 100461351                                           
 With Return Code: 01407
 Error Message   : ORA-01407: cannot update ("SYSADM"."PS_LOAN_ADDRESS"."STATE") to NULL
 
Error W/FAPLDAD2 @ 16:10:27.69 !

 

 

Changes

The process is failing in the FAPLDAD2.cbl program which is called by FAPLBOG1.cbl

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