Fusion Global HR: PER_PERIODS_OF_SERVICE Table and Accepted Termination Date
Last updated on FEBRUARY 21, 2018
Applies to:Oracle Fusion Global Human Resources Cloud Service - Version 220.127.116.11.0 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