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: Check the columns in the reconciliation query. Verify that the query name mentioned as the value of the Query Name attribute of the scheduled task is correct. See Section 3.2.7.1, "Attributes of the Scheduled Tasks" for more information. Verify that all the columns in the reconciliation query are correctly mapped in the lookup definition used for reconciliation. See Section 1.5.4, "Lookup Definitions Used During Reconciliation" for more information.
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: Parameter	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.