FRM-40735: ON-INSERT Trigger Raised Unhandled Exception ORA-29273

If you have a newly installed Vision instance and you are trying to create a location, you might end up getting this error. Which means you can’t create a location and your get the error Create Location gives error: FRM-40735: ON-INSERT Trigger Raised Unhandled Exception ORA-29273 You might be wondering how do i proceed??? The solution is simple. Look at the profile: IRC: Geocode Host and make sure that there is no value for that. Sometimes there is an url as the value at the site level and that causes the problem. Remove it and save your work. You should be good to go.

December 22, 2017

4 responses on "Create Location error: FRM-40735: ON-INSERT Trigger Raised Unhandled Exception ORA-29273"

PadmanabhanOctober 17, 2014 at 12:40 am Log in to Reply

Correct Answer
isudhakarOctober 29, 2015 at 9:22 pm Log in to Reply

Good Answer, Saved The Day!
sam December 3, 2017 at 1:18 pm Log in to Reply

hi am getting this error msg while trying to create my batch invoice FRM-40735 WHEN -VALIDATE TERM TRIGGER RFAISED UNTITLED EXAM, I am trying to create a batch invoice , its giving error on the site . Someone please help