"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 11.1.1.4.0 and later
Information in this document applies to any platform.

Symptoms

On a UCM 11.1.1.4 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.

!csRmaUnableRunDispositionAction!csServiceDataException,RMA_SCRUB_RECORD,Ucont
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
identifier
!syJavaExceptionWrapper,java.sql.SQLSyntaxErrorException:
ORA-00904: "XRECORDDESTROYDATE": invalid identifier

intradoc.common.ServiceException:
!csServiceDataException,RMA_SCRUB_RECORD,UcontentDestroyDate!$
at
intradoc.server.ServiceRequestImplementor.buildServiceException(ServiceRequest
Implementor.java:2115)
at intradoc.server.Service.buildServiceException(Service.java:2260)
at intradoc.server.Service.createServiceExceptionEx(Service.java:2254)
at intradoc.server.Service.createServiceException(Service.java:2249)"

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