Learn about Redwood and be one of the first to join the conversation

Visit Redwood Community
While creating Value set on oracle fusion getting error.The value column is not valid. (FND-2806) — Cloud Customer Connect
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

While creating Value set on oracle fusion getting error.The value column is not valid. (FND-2806)

Received Response
28
Views
2
Comments
edited Jul 5, 2022 11:50AM in Reporting and Analytics for HCM 2 comments

Summary:

The value column is not valid. (FND-2806)

In value set TID_Grade_Value, value column LISTAGG(distinct(prv.value), '; ') WITHIN GROUP(order by prv.value ) "UPGRADE" is not a valid column in the FROM clause.

on select operation given LISTAGG Function

Content (required):

View column (select operation) showing these errors

Version (include the version you are using, if applicable):

Oracle Fusion Cloud Applications 22B (11.13.22.04.0)

Code Snippet (add any code snippets that support your topic, if applicable):


Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!