My Oracle Support Banner

Create New Employee FRM-40735: ON-INSERT trigger raised unhandled exception ORA-06502 (Doc ID 2399446.1)

Last updated on OCTOBER 17, 2019

Applies to:

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


When attempting to create a new employee in Global Super HRMS Manager Responsibility or using API after employee number generation was changed from Manual to Automatic
the following error occurs.

Form error -> FRM-40735: ON-INSERT trigger raised unhandled exception ORA-06502
API error -> Error: ORA-20001: The argument time_normal_finish is not in the correct Time format HH:MM.
The value Y must be in the correct Time format. Where, HH indicates the hour of the day with an integer between 0 to 23, and MM indicates the minute of the hour with an integer between 0 to 59.
PL/SQL procedure successfully completed.

The issue can be reproduced at will with the following steps:
1. Change employee number generation from Manual to Automatic
2. Try to create any new employee trough form or API
3. Error is raised


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.