4 Replies Latest reply: Jan 29, 2013 4:34 PM by Rajiv Dewan RSS

    BI-Publisher with OIM - error opening reports

      I have BI-Publisher installed with OIM and have run into a problem while trying to view reports.

      If I run any of the reports, I get an error stating:
      Parameter name: p_varchar_EmpStatus ORA-00942: table or view does not exist ; Data source: OIM JDBC; Query: SELECT LKV_ENCODED AS UserStatus FROM LKV, LKU WHERE LKV.LKU_KEY=LKU.LKU_KEY AND LKU_TYPE_STRING_KEY = 'Lookup.WebClient.Users.Status' UN

      I'm not sure where I went wrong. I extended the schema using the RCU for OIM 11.1.2. I have the JDBC connection set up and functioning.

      Any ideas?