You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register
Get Started: AI Resources for Oracle Cloud HCM – Go Here

Progress with Redwood: Redwood Resources for Oracle Cloud HCM -  Go Here

Subqueries in Logical SQL

edited Nov 12, 2020 11:25PM in Reporting and Analytics for HCM 4 comments

Summary

I've probably failed at some simple syntax..

Content

Attempting to build some fairly complex queries using Logical SQL Analysis in OTBI.

This query:
SELECT
"Worker"."Person Number",
"Worker"."Employee List Name",
"Worker"."Person Type"
FROM "Workforce Management - Worker Assignment Real Time"

Does exactly what you'd expect

 

This query:

SELECT
A.PerNum,
A.EmpName,
A.PerType

FROM
(
SELECT
"Worker"."Person Number" PerNum,
"Worker"."Employee List Name" EmpName,
"Worker"."Person Type" PerType
FROM "Workforce Management - Worker Assignment Real Time"
) A

Throws the following error:

 

View Display Error 

Error generating view. Error getting cursor in GenerateHead
  Error Details
Error Codes: 

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!