How can i do Join in this two suject areas Human Capital Mgmt – Transaction X Document of Records

AlexSantos

We need the report to documents of records and datas about approvals in Console Transaction. We are using this subjects areas:

Human Capital Management – Transaction Administration Real Time

Workforce Management - Documents of Record Real Time

We cant identify the common attribute to join this subject areas

Regards

RichardChan

If there are no common attributes then there will be an issue in joining. Can you double check as it seems you see a relationship between these subject areas

MandeepGupta

Hi @AlexSantos ,

I think it should be possible using object_id from transaction analysis to dor id from DOR Subject areas. There are many examples for different objects on customer connect. Check below posts:

Assignment Approvals — Cloud Customer Connect (oracle.com)

Goal Plan Approvals — Cloud Customer Connect (oracle.com)

Join subject areas Human Capital Management and Recruiting — Cloud Customer Connect (oracle.com)

OTBI anlaysis using "Human Capital Management - Transaction Administration Real Time" & " Workforce Management - Absence Real Time" and Report shows all the Approver details (Doc ID 2717457.1)

Thanks.

Nathan CCC

Hi,

Assume the common dimension is the unique identifier of a person (or alternative business group id concatenated with upper person number) so join the subject areas using that common thing

select all a.*, b.* from

(select all 0 as s_0, "presentationtable"."presentationcolumn" as person_id, … 

from "Subject Area A") a //A is some subject areas with person in it

left outer join 

(select all 0 as s_0, "Worker"."Person ID" as person_id #, … other cols

from "Workforce Management - Documents of Record Real Time") b 

on (a.person_id = b.person_id)