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

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

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