Oracle Forms - Symptoms

In the FNDSCAUS (define user) form, in the person field, insert %xyz% and an error message is generated.

Error

FRM-40735: ON-ERROR trigger raised unhandled exception ORA-01001.

Steps

The issue can be reproduced at will with the following steps:

• Log in to sysadmin responsibility
• Go to Security->User->Define
• Query any user. Go to Person field and put some name, like %xyz%
• Click Cntrl+L to get list of values, the error is generated with the FRM-40735 : ON-ERROR trigger raised unhandled condition ORA-01001 error in bottom of form.
• Get another popup with more detailed hostdef error.
• Then popup with ora-01001 error
• Then popup with frm-92100 error, which kicks user out of form.

Cause

This issue is caused by database initialization parameters not being set.

The following parameters were not set in the database environment:

_system_trig_enabled
_sort_elimination_cost_ratio
_like_with_bind_as_equality
_fast_full_scan_enabled
_sqlexec_progression_cost

Solution

To implement the solution, please execute the following steps:

1. Set the following parameters in the database init.ora file:

system_trig_enabled = true
_sort_elimination_cost_ratio = 5
_like_with_bind_as_equality = TRUE
_fast_full_scan_enabled = FALSE
_sqlexec_progression_cost = 2147483647

2. Retest the issue.:

3. Migrate the solution as appropriate to other environments: