EC Inbound Agent Fails On INSERT INTO PS_CL_APR_SUP4_EC (Doc ID 2279118.1)

Last updated on JUNE 21, 2017

Applies to:

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

Symptoms

When attempting to run the Inbound EC Agent process (ECIN001) to load in an alternative loan response file,
the following error occurs and is observed on the Business Document Errors

ERROR
-----------------------
A SQL Error was encountered during execution of the EC Driver.

INSERT INTO PS_CL_APR_SUP4_EC ( ECTRANSID,ECQUEUEINSTANCE,ECTRANSINOUTSW,LN_DTL_NBR,CL_UNIQUE_ID4,CL_SUP_BORR_OWN_CD,CL_SUP_BORR_ID_CD,CL_EMAIL_ADDRESS,CL_EMAIL_VALID_IND,CL_EMAIL_EFFDT,CL_BORR_TEMP_AD1_O,CL_BORR_TEMP_AD2_O,CL_BORR_TEMP_CITY3,CL_BORR_TEM





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