APPPROC_REBUILD_CONTEXT_CACHES Is Failing With Exception SQLException: ORA-20734 (Doc ID 2119955.1)

Last updated on JUNE 26, 2017

Applies to:

Oracle Demantra Real-Time Sales and Operations Planning - Version 7.3.1.5 and later
Information in this document applies to any platform.

Symptoms

On : 7.3.1.5 version, Workflow

We have enabled a worksheet for caching.
Worksheet is enabled for "Open with" at Item level (context -> selected member)

We have configured workflow to refresh the cache of worksheet following chapter on 'Worksheet Caching' in implementation guide using procedure 'APPPROC_REBUILD_CONTEXT_CACHES'.

However that procedure APPPROC_REBUILD_CONTEXT_CACHES is failing with exception SQLException: ORA-20734

Workflow is failing with error:

ERROR
-----------------------

java.sql.SQLException: ORA-20734: Column CAN_CREATE_CW missing on table T_EP_ITEM!
ORA-06512: at "DEMANTRA.APPPROC_REBUILD_CONTEXT_CACHES", line 1288
ORA-06512: at line 1



BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, cannot run the workflow for caching the worksheets

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