Skip Headers
Oracle® Identity Manager Connector Guide for Oracle E-Business Employee Reconciliation
Release 9.1.0

E11202-13
Go to Documentation Home
Home
Go to Book List
Book List
Go to Table of Contents
Contents
Go to Index
Index
Go to Feedback page
Contact Us

Go to previous page
Previous
Go to next page
Next
PDF · Mobi · ePub

5 Troubleshooting

Table 5-1 lists errors and exceptions that you might encounter while working with the connector. Solutions to these issues are also provided in the table.

Table 5-1 Troubleshooting Errors Encountered During Connector Operations

Error Solution

ORA-00942: table or view does not exist.

This exception is encountered when an invalid table name is included in the reconciliation query. If this exception occurs, first check the query and then verify that the table exists in the target system database.

ORA-00904: "PAPF"."PERSON_I": invalid identifier.

This exception is encountered when an invalid column name is included in the reconciliation query. If this exception occurs, first check the query and then verify that the column exists in the target system database.

java.sql.SQLException: Invalid column index

This exception is encountered if the code refers to a column that is not present in the reconciliation query. If this exception occurs, then:

ORA-01031: insufficient privileges

This exception is encountered if the target system account used for connector operations does not have the permissions required to connect to the target system tables. If this exception occurs, then:

Ensure that the target system account has the permissions required to connect to all the tables listed in the reconciliation query. To do this, check the GRANT statements in the OimUserGrants.sql and OimUserSynonyms.sql files. See the following sections for more information:

Section 4.5, "Configuring Reconciliation Queries"

Section 2.1.2.1, "Creating a Target System User Account for Connector Operations"

java.sql.SQLException: Attempt to set a parameter name that does not occur in the SQL: Address

This error is encountered if you specify a filter parameter in the Lookup.EBS.HRMS.QueryFilters lookup definition but do not specify the same parameter in the reconciliation query.

java.sql.SQLException: Missing IN or OUT parameter at index

This error is encountered if you specify a filter parameter in the reconciliation query but do not specify the same parameter in the Lookup.EBS.HRMS.QueryFilters lookup definition.