PeopleTools and Lifecycle Management - PSFT (MOSC)

MOSC Banner

Year cannot be zero - Peopletools 8.54

edited Mar 25, 2015 10:01AM in PeopleTools and Lifecycle Management - PSFT (MOSC) 1 commentAnswered

We are upgrading from peopletools 8.51 to 8.54.  In one of our SQRs we are receiving  (1915) Year cannot be zero.

Here is the code :

Begin-SELECT

EN.LM_ENRLMT_ID

EN.LM_CI_ID

EN.LM_ACT_ID

EN.LM_STTS

EN.LM_STTS_CHANGE_DT

EN.LM_COMPL_DT

EN.LM_ENRL_DT

CI.LM_CRSE_CODE

CI.LM_CS_LONG_NM

  let $Individual_Course_Found = 'Y'

   If $Course_Comp_Found = 'N'

            let $LM_STTS           = &EN.LM_STTS

            let $LM_COMPL_DT       = &EN.LM_COMPL_DT  (this is the line it doesn't like.)

            let $LM_TARGET_CMPL_DT = &EN.LM_COMPL_DT

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