Unable to Run Data Load Rule in ERPi for New Period Error: "ORA-01400: cannot insert NULL into ("ERPI"."AIF_ENTITY_LOAD_AUDIT"."MEMBER") "
Last updated on AUGUST 01, 2016
Applies to:Hyperion Financial Data Quality Management - Version 188.8.131.52.00 and later
Information in this document applies to any platform.
This is a specific example where the user was unable to run a data load rule for August 2011 data in EBS. When attempting to run a data load rule for the month of August for Fiscal year 2011 the data load rule fails and returns the following error in ODI Operator:
INSERT INTO AIF_ENTITY_LOAD_AUDIT (
SELECT distinct loadid
FROM aif_hs_balances bal
WHERE loadid = '185'
AND NOT EXISTS (
FROM AIF_ENTITY_LOAD_AUDIT aud
WHERE aud.loadid = bal.loadid
AND aud.member = bal.ENTITY
2010-09-10 10:09:50,634 FATAL [AIF]: Error in EBS Load AIF_HS_BALANCES - Load
Period and Dim Audit Tables
Traceback (most recent call last):
File "<string>", line 213, in ?
java.sql.SQLException: java.sql.SQLException: ORA-01400: cannot insert NULL
2010-09-10 10:09:52,337 INFO [AIF]: COMM End Balances Process Step - Update
HS_BALANCES Details - START
2010-09-10 10:09:52,353 INFO [AIF]: COMM End Balances Process Step - Update
HS_BALANCES Details - END
2010-09-10 10:09:53,087 INFO [AIF]: AIF Integration Process End, Process ID:
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