My Oracle Support Banner

Trigger raised unhandled exception ORA-01840 / ORA-01841 / ORA-01861 / ORA-01403 Errors when Deleting Extra Information Type from Assignment Level (Doc ID 2887634.1)

Last updated on JANUARY 12, 2024

Applies to:

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

Symptoms


When attempting to:

   A. Call hr_assignment_extra_info_api.delete_assignment_extra_info the following error occurs.

ORA-01840: input value not long enough for date format
ORA-06512: at "APPS.HR_ASSIGNMENT_EXTRA_INFO_API", line 739
ORA-06512: at "APPS.PE_AEI_DEL", line 118
ORA-06512: at "APPS.FND_DATE", line 149
ORA-06512: at "APPS.PE_AEI_DEL", line 80
ORA-06512: at "APPS.PE_AEI_DEL", line 319
ORA-06512: at "APPS.PE_AEI_DEL", line 369
ORA-06512: at "APPS.HR_ASSIGNMENT_EXTRA_INFO_API", line 690
ORA-06512: at line 22

   OR

   B.  Delete the Extra Information Type for a person (from Extra Information Type at Assignment level) the following error occurs.

FRM-40735: KEY-DELREC trigger raised unhandled exception ORA-01840

or

FRM-40735: KEY-DELREC trigger raised unhandled exception ORA-01841

or

FRM-40735: KEY-DELREC trigger raised unhandled exception ORA-01861 

  OR

  C. Cancel an employee application

FRM-40735: ON_UPDATE trigger raised unhandled exception ORA-01403


Steps to reproduce:

A.
1. Call hr_assignment_extra_info_api.delete_assignment_extra_info.
2. Error occurs.

OR

B.
Using HRMS Manager responsibility.
1. Navigate to People > Enter and Maintain > Search for a person > Assignment > Others > Extra Information.
2. Try to delete a value.
3. Get error.

OR

C.
1. Under HRMS Manager responsibility or equivalent.
2. Navigate to People  > Enter and Maintain > Query for record > Select Action "Cancel Application"  > Save as Correction.
3. Observe error is displayed.

Changes

 

Cause

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
Symptoms
Changes
Cause
Solution
References


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