My Oracle Support Banner

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

Last updated on MAY 31, 2023

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?


To view full details, sign in with your My Oracle Support account.

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

In this Document

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