My Oracle Support Banner

PJF: FBDI Import Project Gives 'Error on table PJF_PROJECTS_ALL_XFACE, column PROJECT_START_DATE. ORA-01830: date format picture ends before converting entire input string.' (Doc ID 2417551.1)

Last updated on OCTOBER 12, 2018

Applies to:

Oracle Fusion Project Foundation Cloud Service - Version 11.13.18.02.0 and later
Information in this document applies to any platform.

Symptoms

On : 11.13.18.02.0 version, Other Issues

FBDI Import Project errors with: 


ERROR
-----------------------

Record 1: Rejected - Error on table PJF_PROJECTS_ALL_XFACE, column PROJECT_START_DATE.
ORA-01830: date format picture ends before converting entire input string

Record 2: Rejected - Error on table PJF_PROJECTS_ALL_XFACE, column PROJECT_START_DATE.
ORA-01830: date format picture ends before converting entire input string

Looking at the data:

Spreadsheet:

Project Start Date Project Finish Date
2018/01/01        2020/12/31
2018/01/01        2020/12/31

CSV:

1/1/2018            12/31/2020
1/1/2018            12/31/2020

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.