oracle.iam.platform.utils.SuperRuntimeException: java.sql.SQLSyntaxErrorException: ORA-01747: invalid user.table.column, table.column, or column specification ORA-06512: at "DEV_OIM.XL_SP_RECON_USR_MATCH", line 14 ORA-06512: at "DEV_OIM.XL_SP_RECON_USR_DATA_MATCH", line 31 ORA-06512: at line 1at oracle.iam.reconciliation.dao.event.EventMgmtDao.ignoreEventUsrDataMatch(EventMgmtDao.java:449)

Oracle Community | 858703 | 5 years ago
  1. 0

    Error in configuration b/w database application table comnnector and OIMg11

    Oracle Community | 5 years ago | 858703
    oracle.iam.platform.utils.SuperRuntimeException: java.sql.SQLSyntaxErrorException: ORA-01747: invalid user.table.column, table.column, or column specification ORA-06512: at "DEV_OIM.XL_SP_RECON_USR_MATCH", line 14 ORA-06512: at "DEV_OIM.XL_SP_RECON_USR_DATA_MATCH", line 31 ORA-06512: at line 1at oracle.iam.reconciliation.dao.event.EventMgmtDao.ignoreEventUsrDataMatch(EventMgmtDao.java:449)
  2. 0

    EBS Trusted recon

    Oracle Community | 6 years ago | user651347
    oracle.iam.platform.utils.SuperRuntimeException: java.sql.SQLSyntaxErrorException: ORA-00907: missing right parenthesis ORA-06512: at "IDMDEV_OIM.XL_SP_RECON_USR_DATA_MATCH", line 140 ORA-06512: at line 1at oracle.iam.reconciliation.dao.event.EventMgmtDao.ignoreEventUsrDataMatch(EventMgmtDao.java:449)
  3. 0

    OIM 11g: SAP HRMS User Recon

    Oracle Community | 6 years ago | Vitaly
    oracle.iam.platform.utils.SuperRuntimeException: java.sql.SQLException: Invalid character encountered in
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    Error after applying the patch p12748351

    Oracle Community | 5 years ago | LeylaDah
    oracle.iam.platform.utils.SuperRuntimeException: java.sql.SQLSyntaxErrorException: ORA-00907: missing right parenthesis ORA-06512: at "PROD_OIM.XL_SP_RECON_ACCOUNT_DATA_MATCH", line 149 ORA-06512: at line 1at oracle.iam.reconciliation.dao.event.EventMgmtDao.ignoreEventAccountDataMatch(EventMgmtDao.java:527)
  6. 0

    OIM 11.1.1.5 Flat File Reconciliation :

    Oracle Community | 5 years ago | 813370
    oracle.iam.platform.utils.SuperRuntimeException: java.sql.SQLSyntaxErrorException: ORA-00904: "USRMGR"."USR_LOGIN": invalid identifier ORA-06512: at "DEV_OIM.XL_SP_RECON_USR_MATCH", line 14 ORA-06512: at "DEV_OIM.XL_SP_RECON_USR_DATA_MATCH", line 31 ORA-06512: at line 1

    Not finding the right solution?
    Take a tour to get the most out of Samebug.

    Tired of useless tips?

    Automated exception search integrated into your IDE

    Root Cause Analysis

    1. oracle.iam.platform.utils.SuperRuntimeException

      java.sql.SQLSyntaxErrorException: ORA-01747: invalid user.table.column, table.column, or column specification ORA-06512: at "DEV_OIM.XL_SP_RECON_USR_MATCH", line 14 ORA-06512: at "DEV_OIM.XL_SP_RECON_USR_DATA_MATCH", line 31 ORA-06512: at line 1at oracle.iam.reconciliation.dao.event.EventMgmtDao.ignoreEventUsrDataMatch(EventMgmtDao.java:449)

      at oracle.iam.reconciliation.impl.ReconOperationsServiceImpl.ignoreEvent()
    2. oracle.iam.reconciliation
      ReconOperationsServiceImpl.ignoreEvent
      1. oracle.iam.reconciliation.impl.ReconOperationsServiceImpl.ignoreEvent(ReconOperationsServiceImpl.java:380)
      1 frame
    3. Java RT
      Method.invoke
      1. sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
      2. java.lang.reflect.Method.invoke(Method.java:597)
      2 frames
    4. oracle.iam.scheduler
      QuartzJob.execute
      1. oracle.iam.scheduler.impl.quartz.QuartzJob.execute(QuartzJob.java:164)
      1 frame
    5. quartz
      SimpleThreadPool$WorkerThread.run
      1. org.quartz.core.JobRunShell.run(JobRunShell.java:203)
      2. org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:529)
      2 frames