Fusion Global HR: PER_PERIODS_OF_SERVICE Table and Accepted Termination Date (Doc ID 2340713.1)

Last updated on MAY 31, 2023

Applies to:

Goal

We are Trying to Fetch Data which should show when the Manager approves the 'Resignation/Termination' of Employee.

We have tried to get data From PER_PERIODS_OF_SERVICE table( Column - accepted_termination_date).
But this field is empty for all Employees.

Then we tried to get data by using HRC_TXN_DATA table.(Column - Completed_date).
It should give completed date for Resignation/Termination. But when we are using that Column( Completed_date) , the system showing error.

What is the table to use to get the Accepted Termination Date?
 

Solution

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.