Hi N3FKO,
Assume you may refer to field "Department" on an employee or contingent worker or pending worker or nonworker in HCM. In global header select Navigator, select Show More, in Me select work area Personal Information, select Employment Information. Expand section Assignment. View field Department?
Here is the sql for this field for latest update on your assignment effective as at a point in time by default today
select all 0 s_0 , "Worker"."Person Number" as person_number , cast("Worker"."Person ID" as character) as person_identifer , cast("Worker"."Assignment ID" as character) as assignment_identifier , "Worker"."Assignment Start Date" as assignment_start , "Worker"."Assignment End Date" as assignment_end , "Worker"."Effective Latest Change" as assignment_latest , "Worker"."Effective Sequence" as assignment_sequence , "Department"."Department Name" as department_name from "Workforce Management - Worker Assignment Real Time" order by 1 asc nulls last, 2 asc nulls last, 3 asc nulls last, 4 asc nulls last fetch first 7 rows only
Not sure what you mean by sub-department. Maybe something to do with a department hierarchy.
Sorry but no idea what you mean by employee customer. This is HCM. Customers are in ACX/ERP/SCM.
Regards, Nathan
Hi @User_N3FKO ,
Please elaborate more on your requirement. Also, are you looking for BIP query using tables or OTBI (already shared by Nathan).?
Thanks.
Explore how to build agents using code in AI Data Platform. We'll create an agent that examines and analyzes the contents of a Github repository and reports its findings. The session demonstrates how to use different developer tools to create agents including the AIDP extension for VS Code and Codex. Using these tools we…
Our Requisition OTBI analysis is having many values Requisition Number Requisition Title Requisition Status Hiring Manager Full Name Recruiter Full Name am able to see values for all. When am passing Prompt(Hiring Manager Full Name or Recruiter Full Name) am not able to see the data. Am sure we have values/data for passed…
Hi Experts, We are using Oracle BI Publisher Email Bursting to distribute reports via email. Currently, one of our bursting outputs generates a report of approximately 20 MB, and we are trying to understand whether there are any size limitations that could impact email delivery. Scenario: Report Delivery Method: Email…
Team, We have a requirement to select below PVOs HcmTopModelAnalyticsGlobalAM.ProfileAM_ProfileItemPVO HcmTopModelAnalyticsGlobalAM.ProfileAM_ProfilePVO HcmTopModelAnalyticsGlobalAM.ProfileAM_ContentItemPVO HcmTopModelAnalyticsGlobalAM.ProfileAM_ContentTypePVO Do we have any documentation around these?
We have a requirement of enabling OTBI report in Purchase Requisition Redwood page similar to classic UI.How can that be done?
