Change the seeded formula AE_GET_HR_DATA-to handle the case where Projected End Date is stored at Work Terms level
(Doc ID 2342938.1)
Last updated on MARCH 30, 2018
Applies to:Oracle Fusion Global Payroll Cloud Service - Version 184.108.40.206.0 and later
Information in this document applies to any platform.
User has a statutory requirement to calculate Gratuity based on the employee contract details:
"If Employee is on "Fixed Contract" and if he/she resigns from the company after the contract expiry date. He/she will be paid gratuity during his Final settlement."
To achieve the above requirement in their formula they call the Standard formula AE_GET_HR_DATA to get the Contract expiry date using DBI PER_ASG_PROJECTED_ASSIGNMENT_END_DATE.
The DBI does not return any value even after setting the correct assignment ID and Effective date.
User is not getting any values in columns PROJECTED_ASSIGNMENT_END, PROJECT_START_DATE of the table per_all_assignments_m. Due this PER_ASG_PROJECTED_ASSIGNMENT_END_DATE DBI always returns default date.
PER_ASG_PROJECTED_ASSIGNMENT_END_DATE DBI to return the Projected end 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!