APPPROC_REBUILD_CONTEXT_CACHES Is Failing With Exception SQLException: ORA-20734
(Doc ID 2119955.1)
Last updated on DECEMBER 04, 2019
Applies to:Oracle Demantra Real-Time Sales and Operations Planning - Version 18.104.22.168 and later
Information in this document applies to any platform.
On : 22.214.171.124 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
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document