PeopleTools and Lifecycle Management - PSFT (MOSC)

MOSC Banner

DMS Script PeopleTools 8.54 behaves differently with Oracle Date format of 'DD-MON-YYYY'. Is there

edited May 22, 2017 6:07PM in PeopleTools and Lifecycle Management - PSFT (MOSC) 4 commentsAnswered

We have several datamover scripts that we run annually where we select values from the PS_PAY_CALENDAR and we have criteria such as 'And pay_end_dt > '27-DEC-2015', for example.  This same script that we have been running for years in PeopleTools 8.49 no longer works with this date format.  This same query does work in Oracle SQL Plus and SQL Developer in our current database instance.

When the DMS script is modified to change the date using To_Char function, it works fine.  I was just wondering if there is a setting somewhere that controls the date format, or if PeopleTools just changed somewhere along the line to not recognize the 'dd-mon-yyyy' format in Datamover.

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