Learn about the new Oracle AI Agent Studio for Fusion Applications: Watch Now
Progress with Redwood: Redwood Resources for Oracle Cloud HCM - Go Here
Progress with Redwood: Redwood Resources for Oracle Cloud HCM - Go Here
BI report - Worker Assignment Status
Content
I am creating a BI report and I need to show Assignment Status just like how it is showing in OTBI as follows:
Active - Payroll Eligible
Leave - No Payroll
Leave - Payroll Eligible
Terminated - No Payroll
Terminated - Payroll Eligible
I checked the ASSIGNMENT_STATUS_TYPE in the table PER_ALL_ASSIGNMENTS_M and it contains only values 'ACTIVE, INACTIVE, SUSPENDED' . How can I get the same values as the one in OTBI ? Is it in another table or do I have to map it with another column?
0