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

Oracle Community | 813370 | 5 years ago
  1. 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
  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

    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)

    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-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

      at oracle.iam.reconciliation.dao.event.EventMgmtDao.ignoreEventUsrDataMatch()
    2. oracle.iam.reconciliation
      ReconOperationsServiceImpl.ignoreEvent
      1. oracle.iam.reconciliation.dao.event.EventMgmtDao.ignoreEventUsrDataMatch(EventMgmtDao.java:450)
      2. oracle.iam.reconciliation.impl.ReconOperationsServiceImpl.ignoreEvent(ReconOperationsServiceImpl.java:385)
      3. oracle.iam.reconciliation.impl.ReconOperationsServiceImpl.ignoreEvent(ReconOperationsServiceImpl.java:346)
      3 frames
    3. Thor.API.Operations
      tcReconciliationOperationsIntfEJB.ignoreEventx
      1. Thor.API.Operations.tcReconciliationOperationsIntfEJB.ignoreEventx(Unknown Source)
      1 frame
    4. Java RT
      DelegatingMethodAccessorImpl.invoke
      1. sun.reflect.GeneratedMethodAccessor9086.invoke(Unknown Source)
      2. sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
      2 frames