Oracle Community Directory
Oracle Community FAQ
My Oracle Support Community (MOSC)
Go Directly To
Oracle Technology Network Community
My Oracle Support Community
OPN Cloud Connection
Oracle Employee Community
Oracle User Group Community
OTN Speaker Bureau
Performance Management Applications
Financial Data Management
Please enter a title.
You can not post a blank message. Please type your message and try again.
This discussion is archived
: Mar 21, 2012 1:31 PM by
ERPi Data Load to Planning as target application Error
Mar 19, 2012 12:41 PM
I have completed all the ODI and ERPi config but when I go to execute the data load I get an error message:
ORA 01400: cannot insert NULL into ("HYPFDQM","TDATASEG_T","ACCOUNT")
EBS is the source system and I have checked the GL_BALANCES table and there are no records with a NULL account code.
Has anyone got any suggestions on what to check or how to resolve this error?
Any response would be greatly appreciated
This content has been marked as final.
Show 1 reply
Re: ERPi Data Load to Planning as target application Error
Mar 21, 2012 1:31 PM
in response to
The ODI Operator should show the SQL that is being executed and will show that is causing the error. Take a look at the ODI Operator to see the SQL being ran.