Why Does Table PER_ALL_ASSIGNMENTS_F Get Locked When Attempting to Run Batch Element Entries for Element Entries Creation and Absence Creation? (Doc ID 1568222.1)

Last updated on SEPTEMBER 26, 2016

Applies to:

Oracle Human Resources - Version 12.1.3 and later
Information in this document applies to any platform.

Goal

Why does table PER_ALL_ASSIGNMENTS_F get locked when attempting to run batch element entries for Element Entries creation and custom Absence creation program for absence creation?

When attempting to run Batch element entries for Element Entries creation and custom Absence creation program for absence creation, then when
either of the program is running, no other related programs/screens can be accessed because of the locking issue until the program completes.

The following error occurs in such cases.

Case 1:
In session 1, the API HR_ENTRY_API.INSERT_ELEMENT_ENTRY is used to create element entry for assignment ASG123 of person PER123 and
no commit/rollback was issued.

In session 2, the API HR_PERSON_ABSENCE_API.CREATE_PERSON_ABSENCE is used to create Absence for person PER123. Then the API call
errors with the following error.

ORA-20001: The current row is locked

Cause: You are trying to lock a row in the PER_ALL_ASSIGNMENTS_F table which is currently being locked by another user.

Action: Re-query and attempt to lock the row again.
ORA-06512: at "APPS.HR_PERSON_ABSENCE_API", line 1002


Case 2:
In session 1, the API HR_PERSON_ABSENCE_API.CREATE_PERSON_ABSENCE is used to create absence for person PER123 and no commit/rollback was issued.

In session 2, the API HR_ENTRY_API.INSERT_ELEMENT_ENTRY is used to create Element Entry for assignment ASG123 of person PER123 in session 2.
Then the API call errors with the following error.

ORA-20001: The current row is locked

Cause: You are trying to lock a row in the PER_ALL_ASSIGNMENTS_F table which is currently being locked by another user.

Action: Re-query and attempt to lock the row again.
ORA-06512: at "APPS.DT_API", line 2111
ORA-06512: at "APPS.HR_ENTRY", line 3341
ORA-06512: at "APPS.HR_ENTRY_API", line 3748
ORA-06512: at "APPS.HR_ENTRY_API", line 4584
 

Solution

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