Get Started: AI Resources for Oracle Cloud HCM – Go Here
Progress with Redwood: Redwood Resources for Oracle Cloud HCM - Go Here
Progress with Redwood: Redwood Resources for Oracle Cloud HCM - Go Here
Error while joining two subject areas
Summary
Error while joining two subject areas (No fact table exists at the requested level of detail:)Content
I am trying to fetch list of roles that a worker has along with their current department (tied to assignment). I used two subject areas - 'Security - Roles & Privileges Real Time' & 'Workforce Management - Worker Assignment Event Real Time'.
I first inserted only Person Number & Role from Security SA and it worked. I then added 'Worker.Person Number' & 'Department.Name' from Workforce Management - Worker Assignment Event
Real Time SA and then it gave this error. If i remove 'Department.Name' and include only Worker. Person number from 2nd SA, it works fine. Any pointers how to fix this?
0