Fusion Global HR: PER_PERIODS_OF_SERVICE Table and Accepted Termination Date

(Doc ID 2340713.1)

Last updated on FEBRUARY 21, 2018

Applies to:

Oracle Fusion Global Human Resources Cloud Service - Version and later
Information in this document applies to any platform.


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?


Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms