Course Session Roster Report (TRN002) - Error In BI Publisher Prevents Report Completion (Doc ID 1625544.1)

Last updated on OCTOBER 09, 2015

Applies to:

PeopleSoft Enterprise HRMS Human Resources - Version 9.1 to 9.2 [Release 9]
Information in this document applies to any platform.

Symptoms


Whenever the Course Session Roster Report (TRN002) is run, an error prevents it from running to completion. The problem occurs in both English and French.



ERROR
-----------------------
Assignment of "1900-01-01 00:00:00.0000000" to bind.COURSE_START_DT failed.
(2,119) TRN002.Section1.GBL.default.1900-01-01.Step01.OnExecute
Name:ExecXmlpQryReport PCPC:2013 Statement:34

Called from:TRN002.Section1.GBL.default.1900-01-01.Step01.OnExecute
Statement:85

Process 155 ABENDED at Step TRN002.Section1.Step01 (PeopleCode) -- RC = 20
(108,524)

Process %s ABENDED at Step %s.%s.%s (Action %s) -- RC = %s

PSAESRV completed service request at 11.09.04 2013-10-11


STEPS
-----------------------
Navigation:
Enterprise Learning > Course Reports > Course Session Roster

This issue only happens in MSSQL based environment



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