Format prompt selections

User_EQ8R5

Summary

Add specific formatting to prompted selections

Content

Is there a way to format the selections that show for prompts? For instance i need to have a prompt that forces all the selection options to be in upper case, is it possible to add a formula to the prompts to show that to the end user?

Arun Raj

how about using UPPER key word to force any selection to be in upper case?

User_EQ8R5

I think that would probably work but I'm not sure how to use the upper formula in a prompt.

Chris Dabel

Hi,

To do this, edit the column prompt > expand Options, expand the dropdown, then select SQL results.

Then, edit the SQL like this, then save your Prompt/Analysis:

SELECT UPPER("Folder"."Column Name") FROM "Sales - CRM Pipeline" FETCH FIRST 65001 ROWS ONLY

Thanks,
Chris Dabel
Oracle Fusion Support
 

User_EQ8R5

Thanks!