I am not sure whether this is an appropriate forum group to ask this question. If not, please recommend which forum would be more appropriate.
We are trying to extend contingent (or any) employees end-date in Oracle's Human Resources API. Basically, this involves executing a Package using a standard SQL statement.
We are using the API packages, because they are "allowed" by our support agreement, otherwise it would be a simple matter of updating a table directly.
We started by looking at two API calls:
HR_EMPLOYEE_API using the CREATE_EMPLOYEE function, however the EFFECTIVE_END_DATE is output only
HR_PERSON_API using the UPDATE_PERSON function, however the EFFECTIVE_END_DATE is output only
We think we want to edit the PER_ALL_PEOPLE_F table and setting the EFFECTIVE_END_DATE to 60 days in the future, but need to do it through the API. Also, we are not sure if we should be looking at the EMPLOYEE, PERSON or USER APIs.
Any thoughts would be appreciated. Thanks.
Rob