How to fix the Oracle error DRG-10867: OCCURRENCE and COMPLETION score cannot be used with ABOUT in DEFINESCORE?

In this post, you’ll learn more about the Oracle ErrorDRG-10867: OCCURRENCE and COMPLETION score cannot be used with ABOUT in DEFINESCORE with the details on why you receive this error and the possible solution to fix it.

Oracle Error Description

DRG-10867: OCCURRENCE and COMPLETION score cannot be used with ABOUT in DEFINESCORE

Reason for the Error DRG-10867: OCCURRENCE and COMPLETION score cannot be used with ABOUT in DEFINESCORE

Cause: The OCCURRENCE and COMPLETION score cannot be used with ABOUT queries

How to fix the Error DRG-10867: OCCURRENCE and COMPLETION score cannot be used with ABOUT in DEFINESCORE ?

You can fix this error in Oracle by following the below steps

Action: Rewrite the scoring expression.