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

BIP Report LOV becomes read-only when the number of characters increases

Received Response
22
Views
1
Comments
edited Sep 18, 2023 7:26PM in Reporting and Analytics for HCM 1 comment

Summary:


Content (required):

I am trying to build a report with prompts for Degree, Certifications, Languages, Major etc. profile items. I have used SQL queries as LOV to get the content item values to display. The Major for Degrees content type is configured as a free-text field mapped to text 240_1. If I take the distinct values from that field, all other parameters become read only without a drop-down. See screenshot below.

But if I take a substring of the Major field and restrict it to 20 characters, then it shows properly as expected.

The other prompts that I have in this report have values going up to 50 characters and show up fine in the LOV, only the Major field which is mapped to

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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