Load Interface For File Import Is Running In Error For Import Project

(Doc ID 2400341.1)

Last updated on MAY 27, 2018

Applies to:

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

Symptoms

When attempting to load a project using FBDI the following error occurs.

Record 1: Rejected - Error on table PJF_PROJECTS_ALL_XFACE, column PROJECT_NAME.
second enclosure string not present
Record 2: Rejected - Error on table PJF_PROJECTS_ALL_XFACE, column SOURCE_TEMPLATE_NUMBER.
ORA-01400: cannot insert NULL into ("FUSION"."PJF_PROJECTS_ALL_XFACE"."SOURCE_TEMPLATE_NUMBER")

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