Creating New Location is Not Automatically Creating the Associated "GLOG" Refnum Entry For That Location (Doc ID 2094571.1)

Last updated on JANUARY 07, 2016

Applies to:

Oracle Transportation Management - Version 6.3.5 to 6.4.2 [Release 6.3 to 6.4]
Information in this document applies to any platform.

Symptoms

The trigger 'tg_location_refnum' is malformed.

Trigger is:
trigger tg_location_refnum
AFTER INSERT ON location
FOR EACH ROW
BEGIN
execute immediate glog_util.prepare_sql('INSERT INTO location_refnum ( location_gid,location_refnum_qual_gid,
location_refnum_value, domain_name )
VALUES (:1, ''GLOG'', :1, :2') using :new.location_gid, :new.domain_name;
EXCEPTION
WHEN OTHERS THEN
NULL;
END;

Trigger is supposed to create a 'GLOG' refnum on any location inserted into the database. But is not doing so as it is incorrectly written.

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