Equation Engine Failed With Return Code: 6536 Reason: ORA-00942 (Doc ID 2045590.1)

Last updated on JULY 07, 2016

Applies to:

PeopleSoft Enterprise CS Student Financials - Version 9 and later
Information in this document applies to any platform.

Symptoms

On CS 9 Bundle 37, tuition calculation returns an error. A Fee Code uses a fee calculation equation that is the cause of the error. This equation calls another equation that uses a custom view. The custom view is used to determine the Class Length % used for the Refund %.

The equation that fails will run to completion if the refund % select is replaced with a hard coded number.

ERROR
-----------------------
Caught exception: Remote program FAPEQRUN failed with return code: 6535. Reason: ORA-00942: table or view does not exist. In section: SQLRT: DA000-FETCH (2,-1)SCC_EQUATION_ENGINE.Equation.OnExecute Name: Execute PCPC: 5079 Statement:114
Called from FUNCLIB_FA_EQTN_PROC_FUNCS.FieldFormula Name: TestPushButton Statement:921
Called from:EQTN_TEST_DATA.GBL.DERIVED_FA.EQTN_TEST_PB.FieldChange Statement:1 (0,0)

Remote program FAPEQRUN failed with return code: 6536. Reason: ORA-00942: table or voew does not exist. In section: SQLRT: DA000-FETCH (2,-1) SCC_EQUATION_ENGINE.Equation.OnExecute Name:Execute PCPC: 5079 Statement:114
Called from FUNCLIB_FA_EQTN_PROC_FUNCS.FieldFormula Name: TestPushButton Statement:921
Called from EQTN_TEST_DATA.GBL.DERIVED_FA_EQTN_TEST_PB.FieldChange Statement:1(2,-1) SCC_EQUATION_ENGINE.Equation.OnExecute Name: Execute PCPC:7164 Statement:137
Called from FUNCLIB_FA.EQTN_PROC_FUNCS.FieldFormula Name:TestPushButton Statement:921
Called from EQTN_TEST_DATA.GBL.DERIVED_FA.EQTN_TEST_PB.FieldChange Statement: 1


Cause

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