PeopleTools and Lifecycle Management - PSFT (MOSC)

MOSC Banner

When creating an outer join in Peopelsoft query I get a defaulted join that is causing my query to f

edited Jan 23, 2014 3:50AM in PeopleTools and Lifecycle Management - PSFT (MOSC) 3 commentsAnswered
A SQL error occurred. Please consult your system log for details.
Error in running query because of SQL Error, Code=936, Message=ORA-00936: missing expression (50,380). The query is pretty basic and run ok with regular join but when I try to out join oth_earns the table below gets automatically joined incorrectly. Please  let me know if you see something that I am doing wrong. I can't change the statement cause it is automatically creates when I begin the outer join criteria.

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