Change the seeded formula AE_GET_HR_DATA-to handle the case where Projected End Date is stored at Work Terms level
Last updated on MARCH 30, 2018
Applies to:Oracle Fusion Global Payroll Cloud Service - Version 18.104.22.168.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
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