Please add a "RAC" column with a checkbox next to the "Use TNS" column in all 3 for the database connection windows: PeopleSoft, Oracle and Generic.
The purpose of this checkbox is two-fold:
- Remind the user entering the connection information that if it is RAC that special configuration is required.
- As a Consultant/Support rep if you have the client do a "Select" against one of those tables and if you see that "RAC" is set to YES but either "Use TNS" or "TNS Entry" is blank, you will know immediately that there is an issue.
Alternatively you write a validation routine on the "Save Event" to make sure that if "RAC" is checked then "Use TNS" is checked and "TNS Entry" has an entry. Just please do not prevent a user from entering the TNS entry just because "RAC" is not checked, but I would be happy with a checkbox!
Thank you!
