PS Query & SQL

Has any one had any issues running queries with record CLASS_TBL_SCTY?  We have several queries that have run successfully for years that are no longer yielding any results.  All of the individuals running the queries have not had any changes to their security setup including row-level security.  I have put in a help request with Oracle but wanted to check in to see if anyone in the HEUG community has experienced this.  We are currently on the following versions:

HI Jill,

Several tables that use OPRID as a key field have a built-in security "feature" where they limit results to the OPRID of the current user. Depending on the nature of the query you could be running into a piece of criteria that creates no results.

Have someone with Query Manager access click on the View SQL button and see if the SQL has an extra line limiting the OPRID to only the current user. 

--

Jeffrie Brooks | BUSINESS SYSTEM ANALYST UNIVERSITY OF MICHIGAN | INFORMATION AND TECHNOLOGY SERVICES 734-647-8763 | jedobr@umich.edu

Has any one had any issues running queries with record CLASS_TBL_SCTY?  We have several queries that have run successfully for years that are no longer yielding any results.  All of the individuals running the queries have not had any changes to their security setup including row-level security.  I have put in a help request with Oracle but wanted to check in to see if anyone in the HEUG community has experienced this.  We are currently on the following versions:

HI Jill,

Several tables that use OPRID as a key field have a built-in security "feature" where they limit results to the OPRID of the current user. Depending on the nature of the query you could be running into a piece of criteria that creates no results.

Have someone with Query Manager access click on the View SQL button and see if the SQL has an extra line limiting the OPRID to only the current user. 

--

Jeffrie Brooks | BUSINESS SYSTEM ANALYST UNIVERSITY OF MICHIGAN | INFORMATION AND TECHNOLOGY SERVICES 734-647-8763 | jedobr@umich.edu

Has any one had any issues running queries with record CLASS_TBL_SCTY?  We have several queries that have run successfully for years that are no longer yielding any results.  All of the individuals running the queries have not had any changes to their security setup including row-level security.  I have put in a help request with Oracle but wanted to check in to see if anyone in the HEUG community has experienced this.  We are currently on the following versions:

Hello Jill,

If that is the case, then go into query properties and change the Query Type to Process:

That will allow you to see anyone regardless of OPRID restrictions.

HI Jill,

Several tables that use OPRID as a key field have a built-in security "feature" where they limit results to the OPRID of the current user. Depending on the nature of the query you could be running into a piece of criteria that creates no results.

Have someone with Query Manager access click on the View SQL button and see if the SQL has an extra line limiting the OPRID to only the current user. 

--

Jeffrie Brooks | BUSINESS SYSTEM ANALYST UNIVERSITY OF MICHIGAN | INFORMATION AND TECHNOLOGY SERVICES 734-647-8763 | jedobr@umich.edu

Has any one had any issues running queries with record CLASS_TBL_SCTY?  We have several queries that have run successfully for years that are no longer yielding any results.  All of the individuals running the queries have not had any changes to their security setup including row-level security.  I have put in a help request with Oracle but wanted to check in to see if anyone in the HEUG community has experienced this.  We are currently on the following versions:

Hi Dan!

I just tried that and still no results. 

Hello Jill,

If that is the case, then go into query properties and change the Query Type to Process:

That will allow you to see anyone regardless of OPRID restrictions.

HI Jill,

Several tables that use OPRID as a key field have a built-in security "feature" where they limit results to the OPRID of the current user. Depending on the nature of the query you could be running into a piece of criteria that creates no results.

Have someone with Query Manager access click on the View SQL button and see if the SQL has an extra line limiting the OPRID to only the current user. 

--

Jeffrie Brooks | BUSINESS SYSTEM ANALYST UNIVERSITY OF MICHIGAN | INFORMATION AND TECHNOLOGY SERVICES 734-647-8763 | jedobr@umich.edu

Has any one had any issues running queries with record CLASS_TBL_SCTY?  We have several queries that have run successfully for years that are no longer yielding any results.  All of the individuals running the queries have not had any changes to their security setup including row-level security.  I have put in a help request with Oracle but wanted to check in to see if anyone in the HEUG community has experienced this.  We are currently on the following versions:

Hello Jill,

If that is the case, then go into query properties and change the Query Type to Process:

That will allow you to see anyone regardless of OPRID restrictions.

HI Jill,

Several tables that use OPRID as a key field have a built-in security "feature" where they limit results to the OPRID of the current user. Depending on the nature of the query you could be running into a piece of criteria that creates no results.

Have someone with Query Manager access click on the View SQL button and see if the SQL has an extra line limiting the OPRID to only the current user. 

--

Jeffrie Brooks | BUSINESS SYSTEM ANALYST UNIVERSITY OF MICHIGAN | INFORMATION AND TECHNOLOGY SERVICES 734-647-8763 | jedobr@umich.edu

Has any one had any issues running queries with record CLASS_TBL_SCTY?  We have several queries that have run successfully for years that are no longer yielding any results.  All of the individuals running the queries have not had any changes to their security setup including row-level security.  I have put in a help request with Oracle but wanted to check in to see if anyone in the HEUG community has experienced this.  We are currently on the following versions: