Format prompt selections

Question

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?

User_EQ8R5 · Answer

Thanks!

Chris Dabel · Answer

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 · Answer

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