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 AUGUST 01, 2016

Applies to:

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

Symptoms

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 (
loadid
,member
)
SELECT distinct loadid
,ENTITY
FROM aif_hs_balances bal
WHERE loadid = '185'
AND NOT EXISTS (
SELECT 1
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
into ("ERPI"."AIF_ENTITY_LOAD_AUDIT"."MEMBER")
.
.
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:
185



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