PeopleTools and Lifecycle Management - PSFT (MOSC)

MOSC Banner

nVision Scope Value Table

edited Aug 1, 2017 4:07AM in PeopleTools and Lifecycle Management - PSFT (MOSC) 11 commentsAnswered

Hello,

I've created a view, which shows only those projects that exist in the PROJ_RESOURCE table.

SELECT A.PROJECT_ID   FROM PS_PROJECT A  WHERE EXISTS (  SELECT DISTINCT 'X'   FROM PS_PROJ_RESOURCE B  WHERE B.BUSINESS_UNIT = A.BUSINESS_UNIT    AND B.PROJECT_ID = A.PROJECT_ID)   ORDER BY 1

When this view is used as the Value Table in the nVision Scope and run for All Detail Values, the nVision report generates a single report for each project for the business unit, - even those projects that do not exist in the view. Which means that it doesn't really matter what Value table is selected. What can I do to the view to make sure the report generates for only those values (projects) that exist in the view?

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

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

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center