Error Using Batch Processing in FDM "ORA-01400: cannot insert NULL" (Doc ID 1487825.1)

Last updated on MARCH 08, 2017

Applies to:

Hyperion Financial Data Quality Management - Version 11.1.2.1.000 and later
Information in this document applies to any platform.

Symptoms


When importing with the batch loader receiving the error
Description...................................... ORA-01400: cannot insert NULL into ("FDM"."TDATAARCHIVE"."PERIODKEY") INSERT INTO tDataArchive (ArchiveDocKey, PartitionKey, CatKey, PeriodKey, ArchiveFileName, ArchiveExtension, ArchiveDocTypeID, ArchiveProcTypeID, ArchiveTimeStamp, ArchiveDesc, ArchiveCreator, ArchiveSetID) VALUES (N'A@FPL_FIN2HFM-0024@BP13@MAR - 2013@RR-Q375679-2012-08-28 18:37:39.821', 763, 16, '', N'a@FPL_FIN2HFM-0024@BP13@Mar - 2013@RR', N'txt', 1, 1, N'20120828 18:37:39', '', N'q375679', 0)

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