My Oracle Support Banner

Fusion Workforce Compensation: Not Able To Create Dynamic Condition In The Worksheet using Alpha-Numeric characters (Doc ID 2481575.1)

Last updated on FEBRUARY 01, 2019

Applies to:

Oracle Fusion Workforce Compensation Cloud Service - Version and later
Information in this document applies to any platform.


When attempting to create a dynamic calculation condition for the CMP_CWB_CUST_COL_49_LIST lookup (with the lookup code set as alphanumeric), attached to the Numeric Column 17 in the worksheet,
the following error occurs.

1. The expression is invalid. Verify the Syntax. (CMP- 1005198)
2. An Invalid Column Name or Operator "YYY" was found (CMP- 1005201)

The issue can be reproduced at will with the following steps:
1. Create Common Lookup CMP_CWB_CUST_COL_49_LIST and add it to the Numeric Column 17, for example, in the worksheet.
2. Try to create Dynamic condition using this Lookup in compensation worksheet.
3. See the error messages




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

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.