Create ROD Database on OTM Version 6.0.1 Fails (Doc ID 944962.1)

Last updated on SEPTEMBER 08, 2016

Applies to:

Oracle Transportation Management - Version 6.0.1 and later
Information in this document applies to any platform.
***Checked for relevance on 08-Oct-2012***


Symptoms

-- Problem Statement:
On 6.0.1, When attempting to run the ROD scripts in 11g Oracle Database, the following error occurs:
Also, errors occur when installing ROD on a 10 g Database

ERROR
On 11g Database some of the errors are,
Error executing following code:
create materialized view ACCESSORIAL_BASIS_PRECEDENCE BUILD DEFERRED REFRE
SH FORCE WITH PRIMARY KEY AS select RATE_OPERAND_GID,PRECEDENCE,DOMAIN_N
AME,INSERT_USER,INSERT_DATE,UPDATE_USER,UPDATE_DATE from ACCESSORIAL_BASIS
_PRECEDENCE@OLTP.GC3
ORA-30372: fine grain access policy conflicts with materialized view
__________________________________________________
__________________________________________________
Error executing following code:
create materialized view ACCESSORIAL_CODE BUILD DEFERRED REFRESH FORCE WI
TH PRIMARY KEY AS select ACCESSORIAL_CODE_GID,ACCESSORIAL_CODE_XID,ACCESS
ORIAL_DESC,APPLY_GLOBALLY,IS_FLOW_THRU,IS_VAT_EXEMPT,DOMAIN_NAME,INSERT_US
ER,INSERT_DATE,UPDATE_USER,UPDATE_DATE from ACCESSORIAL_CODE@OLTP.GC3
ORA-30372: fine grain access policy conflicts with materialized view

On 10g database, some of the errors are,
Warning: Package Body created with compilation errors.

Errors for PACKAGE BODY PKG_ROD:

LINE/COL ERROR
-------- -----------------------------------------------------------------
285/4 PL/SQL: SQL Statement ignored
285/59 PL/SQL: ORA-00942: table or view does not exist

Building new materialized views (without data)...
BEGIN pkg_rod.build_all_mviews('N'); END;

*
ERROR at line 1:
ORA-04063: package body "GLOGOWNER.PKG_ROD" has errors
ORA-06508: PL/SQL: could not find program unit being called: "GLOGOWNER.PKG_ROD"
ORA-06512: at line 1

-- Steps To Reproduce:
The issue can be reproduced at will with the following steps:
1.Try to install ROD on a 11g and a 10g Database
2. see the errors as above


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