E-UPG ORA-01830: date format picture ends before converting entire input string. Error - failure during Copy From File process when writing Maintenance Log table for project.

(Doc ID 1574258.1)

Last updated on JULY 19, 2016

Applies to:

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

Symptoms

On : 8.53 version, Upgrade

When attempting to to migrate projects from one environment to another, the following error occurs.

ERROR
-----------------------
Error Position: 82 Return: 1830 - ORA-01830: date format picture ends before converting entire input string
Failed SQL stmt: SELECT COUNT(*) FROM PS_MAINTENANCE_LOG WHERE UPDATE_ID = :1 AND DTTM_IMPORTED = :2
Error - writing Maintenance Log table for project PRJ897041
Error - failure during Copy From File process.

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Run Application Designer
2. Open project
3. Run Copy From File process.

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot migrate projects from one environment to another.

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