Not Able To Update/Delete Child Dock Appointments (Repeating) When Parent Appointment Is Deleted

(Doc ID 2300068.1)

Last updated on AUGUST 23, 2017

Applies to:

Oracle Warehouse Management - Version 12.2.5 and later
Information in this document applies to any platform.

Symptoms

Trying to update/delete child dock appointments (Repeating) when Parent appointment is deleted user is receiving below error:

ERROR

'Delete repeating Appointment', select 'No' (ON-DELETE trigger raised unhandled exception ORA-01403)

STEPS

The issue can be reproduced at will with the following steps:
1) Create dock door appointment with repeating frequency (every week day)
2) Delete parent dock door appointment (Very first appointment appearing on start date). When system gives message 'Delete repeating Appointment', select 'No'
3) Navigate to one of child appointment and try to delete or update the appointment. System gives an error at this point of time (ON-DELETE trigger raised unhandled exception ORA-01403)


Cause

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms