E1: BSFN: Table Trigger Fails On Get UDC Function X0005

(Doc ID 2354345.1)

Last updated on JANUARY 29, 2018

Applies to:

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

Goal

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?
 

Solution

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