Unable to Run Data Load Rule in ERPi for New Period Error: "ORA-01400: cannot insert NULL into ("ERPI"."AIF_ENTITY_LOAD_AUDIT"."MEMBER") "
(Doc ID 1209543.1)
Last updated on JUNE 22, 2018
Applies to:Hyperion Financial Data Quality Management - Version 18.104.22.168.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:
2010-09-10 10:09:50,524 DEBUG [AIF]:
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:
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!