Errors Running "create_aa_all.sql " Script When Installing FTI for OTM Version 5.5 CU6 (Doc ID 1056110.1)

Last updated on JULY 09, 2014

Applies to:

Oracle Fusion Transportation Intelligence - Version: 5.5.06 and later   [Release: 5.5 and later ]
Information in this document applies to any platform.
***Checked for relevance on 07-Jul-2011***

Symptoms


Installing FTI for OTM 5.5 CU6. In running the following script on the ROD database, it is producing many errors as seen below:

script: \glog\oracle\script8\advanced_analytics\create_aa_all.sql

Errors (subset of)

Creating FTI External Predicates
Connected.
DECLARE
*
ERROR at line 1:
ORA-20000: The External Predicate: [EXISTS (SELECT GL_USER_GID FROM
USER_ASSOCIATION WHERE USER_ASSOCIATION.GL_USER_GID =
SYS_CONTEXT('GL_USER_CTX', 'GL_USER_GID') AND USER_ASSOCIATION_VALUE =
F_SHIPMENT_DAY_MV.SERVPROV_GID AND USER_ASSOCIATION_QUAL = 'SERVPROV')] on
table: F_SHIPMENT_DAY_MV is not valid. Oracle error is: ORA-00942: table or
view does not exist
ORA-06512: at "GLOGOWNER.VPD", line 1058
ORA-06512: at "GLOGOWNER.EN_EXT_POLICIES_EXT_PRED_BIU", line 24
ORA-04088: error during execution of trigger
'GLOGOWNER.EN_EXT_POLICIES_EXT_PRED_BIU'
ORA-06512: at line 18

Creating Keys, Constraints..
ALTER TABLE F_CARRIER_STOP_DELIVERY_DETAIL ADD CONSTRAINT PK_F_CARRIER_STOP_DELIVERY_DET PRIMARY KEY ( SOURCE_LOCATION_GID, DESTINATION_LOCATION_GID, SERVPROV_GID, TRANSPORT_MODE_GID, LANE_GID, AA_SHIPMENT_GID, DW_DATE, STOP_LOCATION_GID,STOP_NUM,PERSPECTIVE)
*
ERROR at line 1:
ORA-00942: table or view does not exist


ALTER TABLE F_CARRIER_STOP_PICKUP_DETAIL ADD CONSTRAINT PK_F_CARRIER_STOP_PICKUP_DETAI PRIMARY KEY ( SOURCE_LOCATION_GID, DESTINATION_LOCATION_GID, SERVPROV_GID, DW_DATE, LANE_GID, STOP_LOCATION_GID, AA_SHIPMENT_GID, TRANSPORT_MODE_GID,STOP_NUM,PERSPECTIVE)
*
ERROR at line 1:
ORA-00942: table or view does not exist



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