APP-HXC-366313 The columns/Quick pick columns Definition in Value set is incorrect (Doc ID 1952638.1)

Last updated on MARCH 09, 2017

Applies to:

Oracle Time and Labor - Version 12.2.3 and later
Oracle Application Object Library - Version 12.2.4 to 12.2.4 [Release 12.2]
Information in this document applies to any platform.

Symptoms

On : 12.2.3 version,

When attempting to add Table Validated Valueset in the Alternate Name Mapping, the following error occurs.

ERROR
-----------------------

APP-HXC-366313 The columns/Quick pick columns Definition in Value set is incorrect
Cause 1: The Columns/Quick pick columns should not contain functions like to_char, substr etc.
2. Should not contain column alias
3. Should not contain characters like $,*,(,).
4. ID field may be null
Action: Please ensure that the value set follows the above conditions


STEPS
-----------------------
The issue can be reproduced at will with the following steps:

1. Value Set Definition
Table Application : Projects
Table Name : PA_PROJECT_ASSIGNMENTS
Value : ASSIGNMENT_NAME
ID : ASSIGNMENT_ID

N> Global OTL Application Developer >
Define Alternate Name Mapping >

Error Occurs while saving the record.

BUSINESS IMPACT

-----------------------
The issue has the following business impact:
Due to this issue, users cannot create Alternate Name Mapping.

Work Around
-------------------
None

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