Error "ORA-01400: cannot insert NULL into ("PEPMFDM"."TDATASEG_T"."AMOUNT")" When Pulling the Data from AIF Open Interface Table to FDMEE
(Doc ID 2549858.1)
Last updated on SEPTEMBER 10, 2023
Applies to:Hyperion Financial Data Quality Management - Version 220.127.116.11.000 and later
Information in this document applies to any platform.
While importing the data from AIF_OPEN_INTERFACE table to Data Management, it fails with an error in Process log as:
"Warning: The Import step has not been completed for period Jan-18"
However in ODI operator log, the error appears as:
"java.sql.SQLIntegrityConstraintViolationException: ORA-01400: cannot insert NULL into ("PEPMFDM"."TDATASEG_T"."AMOUNT")"
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