PeopleTools and Lifecycle Management - PSFT (MOSC)

MOSC Banner

PS Query - Outer Join and Query Security Views

edited Jul 26, 2013 5:34AM in PeopleTools and Lifecycle Management - PSFT (MOSC) 4 commentsAnswered
Hello,

I have to create a query that has multiple outer joins to various tables. One of these tables (HRS_JO_RPL) is defined with query security view. This table may or may not have rows. I need to join it with HRS_JOB_OPENING. I created outer join using an expression with (+) operator. Outer join works fine with table HRS_JO_RPL but Query manager adds security view HRS_JO_SEC_VW without Outer Join so outer join to HRS_JO_RPL doesn't work as expected. And it doesn't show HRS_JOB_OPENING rows that don't have corresponding rows in HRS_JO_RPL.

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