My Oracle Support Banner

Error Deleting Duplicate Instructor (Doc ID 1987332.1)

Last updated on MARCH 04, 2019

Applies to:

Oracle Learning Management - Version 12.1 HRMS RUP7 and later
Information in this document applies to any platform.

Symptoms

On : 12.1.3 version, Resources Definition & Booking



Error Deleting Duplicate Instructor:


ERROR
-----------------------
System Error: Procedure ota_tsr_shd.constraint_error at Step 10 Cause: The procedure ota_tsr_shd.constraint_error has created an error at Step 10. Action: Contact your system administrator quoting the procedure ota_tsr_shd.constraint_error and Step 10.


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
Duplicate instructor was created within the application using Resources>Create Resource, not via API.
Navigation>Resource : Resource Type: Trainer- Person: Smith, Mr. T.
Two Resource names - for Smith, Mr. T.
Same training center
Same location with exception on add the room to the location different start dates.
Try to delete
Error Deleting Duplicate Instructor


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.