title: no duplicates but still constraint violation error
body: <p>I have table in which a constraint has been set on a field called LoginId.While inserting a new row i am getting an error on this constratint associated with this field(LoginID)stating the below error.</p>
  
  <p>The insert command is below:
  Type 1 with sequence</p>
  
  <pre><code>insert into TemplateModule
  (LoginID,MTtype, Startdate TypeId, TypeCase, MsgType, MsgLog, FileName,UserName, CrID, RegionaltypeId)
  values 
  (MODS_SEQ.NEXTVAL,3434,2843,2453,2392,435,2390,'pension.txt','rereee',454545,3434);
  Failed with error
  </code></pre>
  
  <p>Type 2 without sequence a hardcoded value::</p>
  
  <pre><code>insert into TemplateModule
  (LoginID,MTtype, Startdate TypeId, TypeCase, MsgType, MsgLog, FileName,UserName, CrID, RegionaltypeId)
  values
  (3453,3434,2843,2453,2392,435,2390,'pension.txt','rereee',454545,3434)
  </code></pre>
  
  <p>I crosschecked many times for duplicates.But nothing found.What could be the rootcause</p>
  
  <pre><code>ORA-00001: unique constraint error (LGN_INDEX)violated
  </code></pre>