FTE Gain and Loss Validation using OTBI

Question

Has anyone figured out the query/report using OTBI for the validation of these 2 key metrics from the Gains and Losses subject area in FAIDP/FDI? Any help would be highly appreciated.

Raghavendra Raghunath-Oracle · Answer

Hi @pwc123 No, what i meant, you can arrive at gains and losses using the grain of the worker.

* i.e. a worker moves from Department A to Department B.
* The grain of the record here is worker
* You can aggregate by BU/Department/Location/Country/Manager etc using this data

This is in OTBI, for your validation

This aggregation is available OOTB in the Gains and Losses subject area

Note: what would take complex sql queries to arrive at the aggregation by BU/Dept etc, we have made it so easy and simple in FDI, you can do the same using just drag and drop.

Thanks

Raghu

pwc123 · Answer

https://community.oracle.com/products/oracleanalytics/discussion/comment/75780#Comment_75780

Thanks @Raghavendra Raghunath-Oracle. So we’re saying that this can only be validated at the employee/person number level, not for a whole department or a whole BU?

Raghavendra Raghunath-Oracle · Answer

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