Create ROD Database on OTM Version 6.0.1 Fails
(Doc ID 944962.1)
Last updated on JULY 20, 2024
Applies to:
Oracle Transportation Management - Version 6.0.1 and laterInformation in this document applies to any platform.
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
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 |