My Oracle Support Banner

E1: BSFN: Table Trigger Fails On Get UDC Function X0005 (Doc ID 2354345.1)

Last updated on MARCH 05, 2021

Applies to:

JD Edwards EnterpriseOne Tools - Version 9.2 and later
Information in this document applies to any platform.


A trigger was created using Table Design Aid in OMW on tables F4301 and F4311 that includes the use of the Get UDC business function (X0005). The trigger works fine 90% of the time but if the Get UDC function fails to find a record in the specified UDC table the trigger ends and causes a rollback of the transaction that caused the trigger to fire. Code was added in an NER to check for error ID but it seems that portion of code is skipped and the whole transaction is rolled back. Why does this happen? Is this the expected behavior in a trigger? Is there a way to do error handling within a trigger using this function?


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.