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

report on user account details - Role Names

57
Views
4
Comments
edited May 12, 2017 2:09PM in General Transactional Reporting (OTBI) 4 comments

Summary

SQL for reporting on employees roles

Content

Can someone see how to stop the multiple rows from returning in below SQL?

select  "PER_USERS"."USERNAME" as "USERNAME",
  "PER_ROLES_DN_VL"."ROLE_NAME" as "ROLE_NAME",
  "PER_ALL_PEOPLE_F"."ATTRIBUTE3" as "ATTRIBUTE3",
  "PER_PERSON_NAMES_F"."FIRST_NAME" as "FIRST_NAME",
  "PER_PERSON_NAMES_F"."LAST_NAME" as "LAST_NAME",
  "PER_ALL_PEOPLE_F"."EFFECTIVE_START_DATE" as "EFFECTIVE_START_DATE",
  "PER_ALL_PEOPLE_F"."EFFECTIVE_END_DATE" as "EFFECTIVE_END_DATE"
 from "FUSION"."PER_PERSON_NAMES_F" "PER_PERSON_NAMES_F",
 "FUSION"."PER_ALL_PEOPLE_F" "PER_ALL_PEOPLE_F",

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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