My Oracle Support Banner

E-PTF: Date Functions Return Error ( INVALID CONVERSION FROM STRING 1,1,1 TO TYPE LONG ) if using German Language (Doc ID 2227113.1)

Last updated on FEBRUARY 01, 2019

Applies to:

PeopleSoft Enterprise PT PeopleTools - Version 8.55 and later
Information in this document applies to any platform.

Symptoms

PROBLEM STATEMENT:
-----------------------------------
Whenever Date functions are used in PTF and run on machines set on German language, the below error is encountered:


ERROR:
-------------
ErrorHnd: (20003,264)[Test]
Variable &emplid_search set to 05002348
PTF function error: Ungultige Konvertierung von der Zeichenfolge 1,1,1 in Typ Long.
Variable &effdt_row_2 set to MakeDate(Year(Date())|Add(Month(Date())|1)|Day(Date())

English Translation: PTF function error: Invalid conversion from string 1,1,1 to type Long.

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.