My Oracle Support Banner

Site Hub - RRS Objects Invalid After Upgrade to 12.2.8 (Doc ID 2542158.1)

Last updated on JUNE 27, 2023

Applies to:

Oracle Site Hub - Version 12.2.8 and later
Information in this document applies to any platform.

Goal

After performing an upgrade to 12.2.8 the following packages are invalid:

OBJECT_NAME                                                          OBJECT_TYPE            STATUS
==================================    ============      ========
APPS RRS_IMPORT_INTERFACE_PKG                         PACKAGE BODY        INVALID
APPS RRS_SITE_UTILS                                              PACKAGE BODY        INVALID


1) Errors for RRS_SITE_UTILS
"/* $Header: RRSUTILB.pls 120.30.12020000.7 2018/01/02 22:07:07 jinlong ship $ */"

alter package apps.RRS_SITE_UTILS compile body;

Warning: execution completed with warning

Package APPS.RRS_SITE_UTILS altered.

PL/SQL: ORA-00904: "GEOMETRY": invalid identifier
PL/SQL: SQL Statement ignored


2. Errors for RRS_IMPORT_INTERFACE_PKG
"/* $Header: RRSIMINB.pls 120.2.12020000.9 2018/03/09 23:07:32 jinlong ship $ */
"

alter package apps.RRS_IMPORT_INTERFACE_PKG compile body

Warning: execution completed with warning

Package APPS.RRS_IMPORT_INTERFACE_PKG altered.

PL/SQL: ORA-00904: "GEOMETRY": invalid identifier
PL/SQL: SQL Statement ignored
PLS-00364: loop index variable 'SITE_DATA' use is invalid
PL/SQL: Statement ignored
PLS-00364: loop index variable 'SITE_DATA' use is invalid
PL/SQL: Statement ignored
PLS-00364: loop index variable 'SITE_DATA' use is invalid
PL/SQL: Statement ignored
PLS-00364: loop index variable 'SITE_DATA' use is invalid
PL/SQL: Statement ignored
PLS-00364: loop index variable 'SITE_DATA' use is invalid
PL/SQL: Statement ignored
PLS-00364: loop index variable 'SITE_DATA' use is invalid
PL/SQL: Statement ignored
PLS-00364: loop index variable 'SITE_DATA' use is invalid
PL/SQL: Statement ignored
PLS-00364: loop index variable 'SITE_DATA' use is invalid
PL/SQL: Statement ignored
PLS-00364: loop index variable 'SITE_DATA' use is invalid
PL/SQL: Statement ignored

How can these compilation errors be resolved?
 

Solution

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
Goal
Solution


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