electronic Transcript in Peoplesoft
Hello,
I am trying to generate electronic transcript in peoplesoft campus solutions. I updated the EDI_CONV profile according to my DB values and also created a outbound mapping using EDI manager. When I generate the e-transcript it doesn't include my ECTRANSID in etranscript.txt file.
Actually I want to generate and load electronic transcripts in peoplesoft. I generated a sample e-transcript (attached) and then try to load it in peoplesoft it give me this error message
Opening Input file
C:/etranscript_7.txt
SQLError Has Occurred...
#Sql-Status
1400.000000
$SQL-Error
ORA-01400: cannot insert NULL into ("SYSADM"."PS_ECQUEUE"."ECTRANSID")
$SQL-Msg
Error on line 1439: