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 126.96.36.199 and later
Information in this document applies to any platform.
On : 188.8.131.52 version, Engine
Issue with Engine in version 184.108.40.206
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!