Error in inserting record into X_LANE

[JayVal]

Hello all :

I was trying to insert a record into X_LANE table. But I am getting the following error

ORA-01400: cannot insert NULL into ("GLOGOWNER"."HNAME_SET"."INSERT_USER")
ORA-06512: at "GLOGOWNER.RRL", line 78
ORA-06512: at "GLOGOWNER.RRL", line 266
ORA-06512: at "GLOGOWNER.RRL", line 286
ORA-06512: at "GLOGOWNER.X_LANE_AIU", line 30
ORA-04088: error during execution of trigger 'GLOGOWNER.X_LANE_AIU'

I am seeing that there is some trigger which is calling
VPD.get_gl_user and VPD.gmt_sysdate methods. Also down the lane a sys_context method is executed
sys_context('gl_user_ctx','log_in_user_gid')

which return NULL.

Can anyone help on what needs to be done to set this ?

Thanks
Jay

[Nfontes]

Re: Error in inserting record into X_LANE

hi JayVal
you need to delete that last column.
If you leave the title, "insert_user" is going to look for the info and there for give you an error
makesure you delete all columns and lines that are suppose to be empty
sometimes when you are entering info to the CSV file, data gets into fields and corrupts the file.
make sure to have all clear fields our side the data area

regards

[JayVal]

Re: Error in inserting record into X_LANE

Thanks everyone.
We got this. We have log in as glogload user.