My Oracle Support Banner

Criteria With $APPROVER Equal to $USER Causes ORA-01747 Error and Result in Users Not Able to Login (Doc ID 2135513.1)

Last updated on MARCH 08, 2017

Applies to:

Oracle Agile Product Collaboration - Version to [Release to 9.3]
Information in this document applies to any platform.


When added criteria with following


user cannot login and ends with following error during web client login.


ORA-01747: invalid user.table column, table column, or column specification

Steps to Reproduce:

The issue can be reproduced at will with the following steps:

  1.  Login to Java Client and setup following criteria adding following criteria

    $APPROVER Equal To $USER

  2.  Save the criteria
  3.  Login to Web Client



To view full details, sign in with your My Oracle Support account.

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

In this Document

This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process and therefore has not been subject to an independent technical review.
My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.