My Oracle Support Banner

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

Last updated on FEBRUARY 27, 2019

Applies to:

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


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


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


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)


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.