My Oracle Support Banner

Service: ORA-00907 Error When Querying Lov For 'Contactmethod' When Selecting A Contact (Doc ID 1327518.1)

Last updated on JULY 14, 2020

Applies to:

Oracle iSupport - Version 12.1.3 and later
Information in this document applies to any platform.

Symptoms

On 12.1.3, iSupport:

In iSupport, if the profile option 'Oracle iSupport: Employee Contact Point Option for a Service Request' is set to either 'Show all the Contact Points for Self and only work for others' or 'Show only work contact points', the LOV for the Contact Method gives the following error message when adding a new contact for a service request:

 

Error

java.sql.SqlException: ORA-907: missing right parenthesis


Steps to Reproduce

(R) iSupport Employee User
(N) iSupport Home

  1. Create new SR
  2. Complete details until Contact Information Page
  3. Select (B)'Add Contacts'
  4. Enter Contact
  5. Click on spyglass next to Contact by

Workaround
Set the profile option 'Oracle iSupport: Employee Contact Point Option for a Service Request' to 'Show all the contact points'

Changes

 

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Changes
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.