nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Oracle Communities

Oracle AI and Analytics

Child Item

how to get the termination date of managers

User_D9N49

step 1 : get list of managers

step 2 : add "termination date", but it's not for managers, but for workers.

question: how to get the termination date of managers

Find more posts tagged with

OTBI

Accepted answers

gclampitt

You could use a subquery within otbi ie "results based upon another analysis

ie the subquery returns a list of managers, then the main query gets the term date details for these people.

select worker number, term date where worker number in (select manager number…..)

All comments

John Hung-Oracle

Hi, To better serve you, please post your question in the Reporting and Analytics for HCM forum since its specific to HCM subject areas/use cases. Thank you.

gclampitt

You could use a subquery within otbi ie "results based upon another analysis

ie the subquery returns a list of managers, then the main query gets the term date details for these people.

select worker number, term date where worker number in (select manager number…..)

User_D9N49

thank you all for answering~

Upcoming Event

AI Data Platform - Deploying Agents and Agent Hub in AI Data Platform
Learn how to deploy an AI Data Platform agent, register it to the AI Registry, and introduce it to business users through Agent Hub. This session covers how to prepare an agent for deployment, configure endpoint access and authentication, invoke a deployed agent, and monitor it after deployment. The session also introduces…

Top Leaders