APPPROC_REBUILD_CONTEXT_CACHES Is Failing With Exception SQLException: ORA-20734
Last updated on DECEMBER 18, 2017
Applies to:Oracle Demantra Real-Time Sales and Operations Planning - Version 220.127.116.11 and later
Information in this document applies to any platform.
On : 18.104.22.168 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:
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
The issue has the following business impact:
Due to this issue, cannot run the workflow for caching the worksheets
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