PeopleTools and Lifecycle Management - PSFT (MOSC)

MOSC Banner

electronic Transcript in Peoplesoft

edited Jan 18, 2018 4:03AM in PeopleTools and Lifecycle Management - PSFT (MOSC) 2 commentsAnswered

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:

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center