Skip to main content
Question

Delete an object subsription: is a non existing trigger

  • January 29, 2024
  • 1 reply
  • 57 views

Forum|alt.badge.img+7
  • Do Gooder (Customer)
  • 22 replies

Hi!
Someone have created an subscription which i can not delete.
How can i delete this?

The consequence is that one of the background jobs always go to error with text:
"PURCHASE_REQUISITION_TRK_U" is non existing trigger.                    ORA-20105: Assert.IS_TRIGGER

 

 

1 reply

Technical Toby
Superhero (Employee)
Forum|alt.badge.img+14
  • Superhero (Employee)
  • 151 replies
  • January 29, 2024

Hi @awe 

you might check in the database if this trigger had been deactivated. If so, you could simply reactivate it. Then, I guess, you can delete this one.

 

Kind regards,

TT