Hi @pwc123 Validating it from OTBI requires logical sql queries. In the attached example I have the validation for FTE Loss for a specific Department named 'Facilities Prg UK' in the Year 2020. You need to do something similar for other workforce structures like Job, Grade, BU etc. There is a similar post in OTBI, you can check that as well. I have posted the link below.

Thanks

Raghu

OTBI Output

FDI Gains and Losses Output

https://community.oracle.com/customerconnect/discussion/828/worker-current-and-previous-jobs/p1

Hi @pwc123

The short answer to your question is no. A more detailed explanation is below.

“Gains” and “Losses” are not native constructs in Oracle Cloud HCM, and therefore they are not directly available in OTBI as standard metrics. Instead, these values are derived from worker HR transactions, often referred to as HR events (internal mobility).

For example, if Worker A moves from Manager 1 to Manager 2 due to Promotion or Global Transfer, this would be interpreted as:

• A loss of 1 for Manager 1
• A gain of 1 for Manager 2

The same concept can be applied across other workforce dimensions such as Business Unit, Department, Job, Grade, and similar organizational structures.

Currently, OTBI does not provide out-of-the-box metrics that track internal mobility gains and losses across workforce structures. While gains and losses related to Hires and Terminations are available, internal mobility movements are not directly surfaced in this way.

The Gains and Losses metrics that you may see in other analytics contexts are typically derived through curated logic by comparing historical and current worker attributes — for example:

• Previous Department vs. Current Department
• Previous Grade vs. Current Grade
• Previous Manager vs. Current Manager

If you attempt to validate this directly in OTBI, it generally requires building complex logical queries to compare prior and current worker attributes over time.

This is precisely what makes the Gains and Losses subject area valuable—it simplifies the interpretation of internal mobility patterns without requiring complex query logic.

Please feel free to reach out if you have any additional questions.

Thanks

Raghu