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

Sql query is not workinkg

Accepted answer
49
Views
8
Comments
edited Oct 28, 2018 12:12PM in Reporting and Analytics for HCM 8 comments

Content

Hi,

trying to excute the following sql via BI publisher per support document: Doc ID 2187087.1

Select * from per_assignment_supervisors_f sup,
           per_all_people_f pers,
           per_all_assignments_m assign1
where manager_assignment_id in (select distinct assign.assignment_id from per_all_assignments_m assign where PERIOD_OF_SERVICE_ID = '100000000307865')
    and assign1.assignment_id = sup.assignment_id
    and pers.person_id = sup.person_id;


getting error ! see screenshot
glad if someone can assist!

thank you!!

Version

18B

Code Snippet

Select * from per_assignment_supervisors_f sup,
           per_all_people_f pers,
           per_all_assignments_m assign1
where manager_assignment_id in (select distinct assign.assignment_id from per_all_assignments_m assign where PERIOD_OF_SERVICE_ID = '100000000307865')
    and assign1.assignment_id = sup.assignment_id
    and pers.person_id = sup.person_id;

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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