Invalid Objects After Demantra 12.2.2 and Later on a new Install (Doc ID 1607167.1)

Last updated on JUNE 23, 2017

Applies to:

Oracle Demantra Demand Management - Version 12.2.2 to 12.2.4 [Release 12.2]
Information in this document applies to any platform.

Goal

There are invalid objects after demantra 12.2.2 new install.
SQL> select object_name, object_type from dba_objects where status<>'VALID';

OBJECT_NAME
--------------------------------------------------------------------------------
OBJECT_TYPE
-------------------
CTO_CALC
PACKAGE

CTO_CALC
PACKAGE BODY


SQL> alter package CTO_CALC compile ;

Warning: Package altered with compilation errors.

SQL> show error
Errors for PACKAGE CTO_CALC:

LINE/COL ERROR
-------- -----------------------------------------------------------------
30/1 PL/SQL: Declaration ignored
30/54 PLS-00201: identifier 'CTO_CURSOR_POOL' must be declared

How to fix those?
 

Solution

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