My Oracle Support Banner

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

Last updated on JULY 13, 2020

Applies to:

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


On : version, Engine

Issue with Engine in version

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


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

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