PKG_VOYAGE Disabling Only Voyloc Constraint Resulting in ORA-02266 Error (Doc ID 982106.1)

Last updated on SEPTEMBER 02, 2014

Applies to:

Oracle Transportation Management - Version: 5.5.06 to 5.5.06 - Release: 5.5 to 5.5
Information in this document applies to any platform.

Symptoms


On OTM Version,  5.5.06, Following Oracle Transportation Management Data Management Guide
(Release 5.5 Part No. B28770-06 ) item 19 of the document trying to import Voyage schedule data following step 5 by running the following:
-- INSERT PROVIDERS
begin
pkg_voyage.setup_data_source ('LOG_PROV1',1);
end;

-- LOAD SCHEDULES
begin
pkg_voyage.load_schedule(p_partkey => NULL,
p_batchsize => 200,
p_logflag => 'Y');
end;


the following error occurs:

ERROR
-----------------------
ORA-02266: unique/primary keys in table referenced by enabled foreign keys
ORA-06512: at "GLOGOWNER.PKG_VOYAGE", line 361
ORA-06512: at "GLOGOWNER.PKG_VOYAGE", line 761
ORA-06512: at line 3


STEPS
-----------------------
The issue can be reproduced at will with following the following steps:
1.Run the PKG_VOYAGE package to import data
2. See the error happening


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