My Oracle Support Banner

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 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!

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