"Delete Revision and Keep Metadata" Approval Action causing Error in URM Minimal Installation

(Doc ID 1373773.1)

Last updated on MAY 10, 2017

Applies to:

Oracle WebCenter Content: Records - Version and later
Information in this document applies to any platform.


On a UCM instance with URM enabled for minimal installation, the following error is seen when trying to approve a disposition that has an action of "Delete Revision and keep Metadata".

"Unable to run disposition action. Unable to execute service RMA_SCRUB_RECORD
and function UcontentDestroyDate.
Unable to execute query 'UcontentDestroyDate(UPDATE/*+ INDEX (DocMeta
PK_DocMeta)*/ DocMeta SET xRecordDestroyDate = {ts '2011-07-08 20:39:00.000'}
WHERE dID = 3819)'. ORA-00904: "XRECORDDESTROYDATE": invalid identifier
java.sql.SQLSyntaxErrorException: ORA-00904: "XRECORDDESTROYDATE": invalid
identifier. [ Details ]
An error has occurred. The stack trace below shows more information.

entDestroyDate!$!csDbUnableToExecuteQuery,UcontentDestroyDate(UPDATE/*+ INDEX
(DocMeta PK_DocMeta)*/ DocMeta SET xRecordDestroyDate = {ts '2011-07-08
20:39:00.000'} WHERE dID = 3819)!$ORA-00904: "XRECORDDESTROYDATE": invalid
ORA-00904: "XRECORDDESTROYDATE": invalid identifier

at intradoc.server.Service.buildServiceException(Service.java:2260)
at intradoc.server.Service.createServiceExceptionEx(Service.java:2254)
at intradoc.server.Service.createServiceException(Service.java:2249)"


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