Creating New Location is Not Automatically Creating the Associated "GLOG" Refnum Entry For That Location
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.
The trigger 'tg_location_refnum' is malformed.
AFTER INSERT ON location
FOR EACH ROW
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;
WHEN OTHERS THEN
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.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms