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 9.2.2.4 to 9.3.1.0 [Release 9.2.0.0 to 9.3]
Information in this document applies to any platform.

Symptoms

When added criteria with following

$APPROVER Equal To $USER

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

Error

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

 

Cause

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
Symptoms
Cause
Solution
References


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.