Screen Frozen Content Menu Displays Error: "Unable to get screening results for content and records Error occurred while processing" (Doc ID 1950027.1)

Last updated on FEBRUARY 09, 2016

Applies to:

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

Symptoms

1. Go to Records-> Configure-> Retention -> Freezes

2. Select Actions for one of the records

3. Click on List frozen

4. Click Screen Frozen Content

Following error is received:

Unable to get screening results for content and records Error occurred while processing. Unable to return results. Unable to create the result set for query 'SELECT Revisions.dDocName,Revisions.dID, dDocTitle, dDocType, dRevisionID, dSecurityGroup, dDocAuthor, dDocAccount, dRevLabel, dFormat, dOriginalName, dExtension, dWebExtension, dInDate, dOutDate, dCreateDate, dPublishType, dRendition1, dRendition2, dFileSize AS VaultFileSize, DocMeta.*, RevClasses.* FROM Revisions, DocMeta, Documents , RevClasses WHERE Revisions.dID=DocMeta.dID And Revisions.dID=Documents.dID And Revisions.dDocName = RevClasses.dDocName And dIsPrimary=1 AND (((AND (Revisions.dID IN ( SELECT FreezeReasonsMap.dID FROM FreezeReasonsMap WHERE FreezeReasonsMap.dObjectType = 'record' AND FreezeReasonsMap.dFreezeID = 'EXERGY DEVELOPMENT' AND (FreezeReasonsMap.dSource = '' OR FreezeReasonsMap.dSource IS NULL)))))) ORDER BY dInDate DESC'. ORA-00936: missing expression
java.sql.SQLSyntaxErrorException: ORA-00936: missing expression.

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