ELM 9.2 : After Creating a New Term in Active Analytics Framework (AAF), Receive Error Message When Add Run Control for Maintain Cache. (Doc ID 2161518.1)

Last updated on OCTOBER 19, 2016

Applies to:

PeopleSoft Enterprise ELM Enterprise Learning Management - Version 9.2 to 9.2 [Release 9]
Information in this document applies to any platform.

Symptoms

After creating a new Term in Active Analytics Framework, Receive error message when add Run control for Maintain Cache.


ERROR:

SQLExec: Failed to find a matching SQL statement for EOCF_CLRCACHE_CHECKFIRST, GBL, 2, 2016-05-10. (2,289) EOCF_CLR_CACHE2.EOCF_DO_SYNC_CACHE.FieldFormula  PCPC:63  Statement:1

The requested SQL statement could not be found.


Steps to Replicate Issue:

1) Log in as Administrator
2) Navigate to Main Menu > Enterprise Components > Active Analytics Framework > Setup > Maintain Cache
3) Add a New Value for Run Control
4) {click} Add button and receive error Message.  


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