Where Used Report Fails With Message : An Unexpected Error Has Occurred

(Doc ID 1919585.1)

Last updated on JANUARY 20, 2016

Applies to:

Oracle Agile Product Collaboration - Version and later
Information in this document applies to any platform.


When executing the "Where used" report, the following error occurs.

ERROR: An unexpected error has occurred. Please contact your system administrator

The issue can be reproduced at will with the following steps:
1. Log into the webclient
2) Run the "Where used" report for an item

When debug is enabled, below error is captured in the log file.

      at weblogic.servlet.provider.ContainerSupportProviderImpl$WlsRequestExec
       at weblogic.work.ExecuteThread.execute(ExecuteThread.java:256)
       at weblogic.work.ExecuteThread.run(ExecuteThread.java:221)
<2014-08-17 23:01:51,381> <WhereUsedRpt:ERROR> Exception in handleItem:
ORA-00904: "A"."MODEL_REF": invalid identifier

ORA-00904: "A"."MODEL_REF": invalid identifier

java.sql.SQLSyntaxErrorException: ORA-00904: "A"."MODEL_REF": invalid identifier

      at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:445)
       at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:396)
       at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:879)
       at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:450)
       at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:192)
       at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:531)
       at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.


Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms