Warning Errors When Running Create_aa_all.Sql

(Doc ID 472736.1)

Last updated on SEPTEMBER 08, 2016

Applies to:

Oracle Transportation Management - Version: 5.5.04
This problem can occur on any platform.

Symptoms

-- Problem Statement:
On 5.5.04, When attempting to run the script, @hdowner_recompile_invalid_objects.sql
the following error occurs:

ERROR


ORA-24344: success with compilation error
ORA-24344: success with compilation error

-- Steps To Reproduce:
The issue can be reproduced at will with the following steps:
1.after installing CU4, run the advanced analytics scripts, create_aa_all.sql followed by
create_aa_load_hd.SQL
and then run the script, hdowner_recompile_invalid_objects.sql
2.the error messages that 4 objects are invalid appears

-- Business Impact:
The issue has the following business impact:
Due to this issue, users cannot complete advanced analytics installation

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