My Oracle Support Banner

Unable to Delete Employee or Contingent Worker Contract Information in HR (Doc ID 2951023.1)

Last updated on MAY 23, 2023

Applies to:

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


Problem Statement:

The red X delete button is grayed out in "Contracts" form.
When attempting to delete the contract record using API(hr_contract_api.delete_contract), following error occurs.

ERROR at line 1:
ORA-20001: You can not delete this contract as it is referenced by an
ORA-06512: at "APPS.HR_CONTRACT_API", line 980
ORA-06512: at line 21



Steps to Reproduce:
The issue can be reproduced at will with the following steps:

  1.  Login with HRMS Manager responsibility.

  2.  Go to "Contracts" form.
     (N) People > Enter and Maintain > (B) Others > Contract
  3.  Red x (Delete) button is grayed out.

  4.  Error occurs when deleting the contract record using the API.

    Sample script:




To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

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