My Oracle Support Banner

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

Last updated on MAY 06, 2022

Applies to:

Oracle Fusion Transportation Intelligence - Version 5.5.06 and later
Information in this document applies to any platform.

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: <otm_install_path />\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

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.