Create New Employee FRM-40735: ON-INSERT trigger raised unhandled exception ORA-06502
Last updated on MAY 16, 2018
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
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms