My area is OTBI.

Futher functionality is also available in: 23C New Subject Area - Compensation - Workforce Assignment Salary Real Time https://www.oracle.com/webfolder/technetwork/tutorials/tutorial/cloud/r13/wn/compensation/releases/23C/23C-compensation-wn.htm#F28574 New Subject Area - Compensation - Workforce Assignment Salary History…

This functionality was delivered in 22.04 / 22B. Please see: https://www.oracle.com/webfolder/technetwork/tutorials/tutorial/cloud/r13/wn/compensation/releases/22B/22B-compensation-wn.htm#F22334

I would like to add here, that the assembler may allow a table name alias that is not accepted by the system, for example WORKER and POSITION as discussed here, in that case the error codes are ambiguous: https://community.oracle.com/customerconnect/discussion/comment/636924#Comment_636924

See the first paragraph, last sentence. "...will also be updated to FMW 12c"

In the meantime, CAST "Expenses - Expense Transactions Real Time"."Approval Level" as NUMERIC.

In Prompts under Options did you try Choice List Values, SQL Results, and Select where the values are not equal to inactive, or equal to active? You can also list specific column values to display and add them here.

What about multiple views?

I have use cases where these need to be independent actions. On the criteria tab, I need them in one order, on the results tab, they need to be different. For example, when the results tab contains multiple views, then how could this be honored? (The edit icon does not need to be used, the columns can be dragged.)

Hi Stephen, scoping is under way, and we are interested to know more about your request. May I have a greater understanding of the use cases?