My Oracle Support Banner

Engine 2k Log Error PLS-00905: Object TPM.PROCESSTEMPSALESTABLE0 Is Invalid (Doc ID 2422485.1)

Last updated on AUGUST 15, 2018

Applies to:

Oracle Demantra Predictive Trade Planning - Version 12.2.6.2 and later
Information in this document applies to any platform.

Symptoms

On : 12.2.6.2 version, Engine

Issue with Engine in version 12.2.6.2

While running the Engine in "PE" mode, engine finishes successfully. But there are no base forecast written to the Sales_Data table.

When looking in the Engine2k logs we see the following error:

14:37:54:759 Executing stored procedure: ProcessTempSalesTable15
14:37:54:845 ERROR Caught oracle::occi::SQLException & rethrow at: DB_OracleCommand::Execute at executing
14:37:54:845 ERROR DB error (/scratch/demlin/dem_engine/HEAD/engine2k/Source6.3DLL/Common/DB/DB_Oracle.cpp:1279, 02:33:27)
Case (7): Database error: OCCI interface raised Oracle OCCI exception.
Description: ORA-06550: line 1, column 7:
PLS-00905: object TPM.PROCESSTEMPSALESTABLE15 is invalid
ORA-06550: line 1, column 7:
PL/SQL: Statement ignored

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


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