My Oracle Support Banner

E-NV: How Can We Secure The Queries Used By Tabular Layout (nVision) Using Query Type (Doc ID 2397680.1)

Last updated on MAY 22, 2018

Applies to:

PeopleSoft Enterprise PT PeopleTools - Version 8.55 and later
Information in this document applies to any platform.

Goal

We have Production reports using queries (tabular layouts). PeopleBooks mentions about Report query type but we don't see it as an option on the page. When we tried to use Process, we encountered an error saying it can't access the query/unauthorized.

Reporting queries are essentially the same as user queries, except that they are designed to be used by another reporting tool. Reporting queries can be used as data sources for adhoc queries, scheduled queries, Connected Query, Composite Query, Pivot Grid, PS/nVision, Cube Manager, or BI Publisher.

Solution

To view full details, 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 a vibrant support community of peers and Oracle experts.