My Oracle Support Banner

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 and later
Information in this document applies to any platform.


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)


To view full details, 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 a vibrant support community of peers and Oracle experts.